When any files that are in large size moved out or deleted, the reclaiming
of the space at certain operating system level may not be fast enough as
soon as the operation is completed and may take time.. Another possibility
would be that stats are not updated, worth to analyze the tables that are
m
It depends on the type of replication is used.
If it's a slony replication then master continues to work and will catch up
when slave is available.
However if the Streaming replication is used, Matser continues to work if
slave is unavailable till it finds space for WAL archiving on master,
depen
Hi all,
I've set up a tablespace on a different partition from the main data
directory. I moved a few tables and indexes over to the new tablespace
and the disk space used in this new tablespace doesn't match the amount
of data 'freed up' from the main data directory. The tablespace is
sittin
Ook, thanks =)
On 2/20/2013 5:56 PM, Gilberto Castillo wrote:
Hello,
Could explain somebody what will happen, if the slave server fails ?
Will it affect the master functionality/availability ?
nothing!!! the Master continuo work. ;-)))
I'm using simple master-slave replication with 2 serve
>
> Hello,
>
> Could explain somebody what will happen, if the slave server fails ?
> Will it affect the master functionality/availability ?
nothing!!! the Master continuo work. ;-)))
> I'm using simple master-slave replication with 2 servers.
>
>
> --
> Best regards
>
>
> --
> Sent via pgsql-a
Hello,
Could explain somebody what will happen, if the slave server fails ?
Will it affect the master functionality/availability ?
I'm using simple master-slave replication with 2 servers.
--
Best regards
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to
Thanks for the pointer! I think I need to read some docs about the planner
statistics.
I tried 1000 and the result was 36M, closer but not enough.
Then tried 1, it tool half an hour to scan all the pages and got the
accurate number.
Thanks again!
On Wed, Feb 20, 2013 at 6:50 PM, Albe Lauren
Qingbo Zhou wrote:
> I have a table which has ~26M records in it. But pg_class shows ~35M in the
> "reltuples" column.
> last_autovacuum is null, and last_autoanalyze was just on yesterday.
>
> I tried running vacuum analyze on it, but the analyze result shows:
>
> INFO: "[table name]": scanned
Hi,
I have a table which has ~26M records in it. But pg_class shows ~35M in the
"reltuples" column. last_autovacuum is null, and last_autoanalyze was just
on yesterday.
I tried running vacuum analyze on it, but the analyze result shows:
INFO: "[table name]": scanned 3 of 950145 pages, conta
