streaming replication vacuum

From: dhaval jaiswal <dhavallj(at)hotmail(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: streaming replication vacuum
Date: 2011-12-30 06:35:59
Message-ID: SNT117-W43CBBC318F6A8E16B7C841DF920@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.
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
-------------+-----------------+--------------+------------------
| | |

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alexander Farber 2011-12-30 10:03:24 Re: Verifying a timestamp is null or in the past
Previous Message dhaval jaiswal 2011-12-30 06:31:34