- Mailing list pgsql-general

From dhaval jaiswal
Subject
Date
Msg-id SNT117-W45DA3C3CF5D835D633681DF920@phx.gbl
Whole thread Raw
List 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
-------------+-----------------+--------------+------------------
             |                 |              |




pgsql-general by date:

Previous
From: Eduardo Morras
Date:
Subject: Re: Refine Form of My querry
Next
From: dhaval jaiswal
Date:
Subject: streaming replication vacuum