From: | dhaval jaiswal <dhavallj(at)hotmail(dot)com> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | |
Date: | 2011-12-30 06:31:34 |
Message-ID: | SNT117-W45DA3C3CF5D835D633681DF920@phx.gbl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Might be discussed but not clear for the below query.
In async. streaming replication do I need to run VACUUM & ANALYZE on both master & slave as to it is bit to bit replication.
Bec, while querying on master getting below result, but slave's system table is not updated.
select last_vacuum, last_autovacuum, last_analyze, last_autoanalyze from pg_stat_user_tables where relname like 'test';
last_vacuum | last_autovacuum | last_analyze | last_autoanalyze
----------------------------------+-----------------+----------------------------------+------------------
2011-12-30 11:14:02.802973+05:30 | | 2011-12-30 11:14:20.943012+05:30 |
Slave:
select last_vacuum, last_autovacuum, last_analyze, last_autoanalyze from pg_stat_user_tables where relname like 'test';
last_vacuum | last_autovacuum | last_analyze | last_autoanalyze
-------------+-----------------+--------------+------------------
| | |
From | Date | Subject | |
---|---|---|---|
Next Message | dhaval jaiswal | 2011-12-30 06:35:59 | streaming replication vacuum |
Previous Message | David Johnston | 2011-12-29 20:20:19 | Re: Verifying a timestamp is null or in the past |