Re: vacuum on streaming replication

From: Michael Paquier <michael(dot)paquier(at)gmail(dot)com>
To: Andreas Kretschmer <andreas(at)a-kretschmer(dot)de>
Cc: PostgreSQL mailing lists <pgsql-general(at)postgresql(dot)org>, Alex Samad <alex(at)samad(dot)com(dot)au>
Subject: Re: vacuum on streaming replication
Date: 2017-07-31 08:08:50
Message-ID: CAB7nPqShop83Y=FOGS1Tk6Ag2wzCgaosuU+XjhY+TYACmva06w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.
--
Michael

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Chris Travers 2017-07-31 08:11:52 Re: vacuum on streaming replication
Previous Message Andreas Kretschmer 2017-07-31 05:28:05 Re: vacuum on streaming replication