Teja Jakkidi <teja(dot)jakkidi05(at)gmail(dot)com> writes:
> I have an environment with 1 primary and 2 physical stand by instances. We have manually analyzed/ vacuumed tables on primary db recently. Later when we checked analyze, vacuum on stand by dbs in pg_stat_user_tables it returns null. Will vacuum/ analyze do not replicate to stand by instances?? Do we have to run separately on all the Stand by instances??
The data changes will propagate, but those action counters are just
maintained locally to the primary server. Their values on a hot
standby are meaningless, probably always zero, because a standby
*can't* change the data on its own.
regards, tom lane