On Mon, Jul 31, 2017 at 7:28 AM, Andreas Kretschmer <andreas@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.
