Re: vacuum on streaming replication

On Mon, Jul 31, 2017 at 10:08 AM, Michael Paquier <michael(dot)paquier(at)gmail(dot)com
> wrote:

> On Mon, Jul 31, 2017 at 7:28 AM, Andreas Kretschmer
> <andreas(at)a-kretschmer(dot)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(at)postgresql(dot)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