Re: Vacuum of large tables causing replication delays to hot standby

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Vacuum of large tables causing replication delays to hot standby
Дата
Msg-id 22825.1462037833@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Vacuum of large tables causing replication delays to hot standby  (Jeff Mcdowell <Jeff.Mcdowell@panerabread.com>)
Ответы Re: Vacuum of large tables causing replication delays to hot standby  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Re: Vacuum of large tables causing replication delays to hot standby  (Jeff Mcdowell <Jeff.Mcdowell@panerabread.com>)
Список pgsql-general
Jeff Mcdowell <Jeff.Mcdowell@panerabread.com> writes:
> 95% of the time, the delay is only microseconds. But we have discovered that whenever the master does an auto vacuum
ofa large table, the transaction replay delay can climb is high as 1 hour. These delays don�t seem to correlate with
anyparticular queries that are running against the master or the standby, and the delay only subsides when the vacuum
completes.

What PG version might this be?

            regards, tom lane


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

Предыдущее
От: Jeff Mcdowell
Дата:
Сообщение: Vacuum of large tables causing replication delays to hot standby
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: Vacuum of large tables causing replication delays to hot standby