On Mon, Jul 31, 2017 at 10:08 AM, Michael Paquier <michael.paqu...@gmail.com > wrote:
> On Mon, Jul 31, 2017 at 7:28 AM, Andreas Kretschmer > <andr...@a-kretschmer.de> wrote: > > The standby is read only, vacuum runs on the master and replicated to > the standby. Analyse as well. > > Please note as well that if hot_standby_feedback is enabled, the > cleanup done by VACUUM on the primary is influenced as well so as > tuples that a standby may need to avoid conflicts for its transactions > are not removed. So VACUUM may result in less cleanup depending on the > read load on the standby. > Also that replication slots provide standby feedback and may further delay vacuuming when the standby is offline. > -- > Michael > > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > -- Best Wishes, Chris Travers Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor lock-in. http://www.efficito.com/learn_more
