Thanks On 31 July 2017 at 18:11, Chris Travers <chris.trav...@gmail.com> wrote:
> > > 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 >
