Postgres Pro
Downloads
Home   >   mailing lists

Vacuum and analyze for objects on physical stand by dbs - Mailing list pgsql-admin

From Teja Jakkidi
Subject Vacuum and analyze for objects on physical stand by dbs
Date
Msg-id FEFF9714-8435-4FE4-9F7D-034F687BEF06@gmail.com
Whole thread Raw
Responses Re: Vacuum and analyze for objects on physical stand by dbs  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
Tree view 
Hello Admins,

I have an environment with 1 primary and 2 physical stand by instances. We have manually analyzed/ vacuumed tables on
primarydb 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?? 

Thanks,
Teja. J.

pgsql-admin by date:

Previous
From: pradeep pandey
Date:
Subject: Re: EOL of Pglogical replication support
Next
From: Tom Lane
Date:
Subject: Re: Vacuum and analyze for objects on physical stand by dbs