Re: [GENERAL] vacuum on streaming replication

Поиск
Список
Период
Сортировка
От Michael Paquier
Тема Re: [GENERAL] vacuum on streaming replication
Дата
Msg-id CAB7nPqShop83Y=FOGS1Tk6Ag2wzCgaosuU+XjhY+TYACmva06w@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [GENERAL] vacuum on streaming replication  (Andreas Kretschmer <andreas@a-kretschmer.de>)
Ответы Re: [GENERAL] vacuum on streaming replication
Список pgsql-general
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.
--
Michael


В списке pgsql-general по дате отправления:

Предыдущее
От: Andreas Kretschmer
Дата:
Сообщение: Re: [GENERAL] vacuum on streaming replication
Следующее
От: Chris Travers
Дата:
Сообщение: Re: [GENERAL] vacuum on streaming replication