|
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 -------------+-----------------+--------------+------------------ | | | |
