Re: Postgres Replaying WAL slowly

Поиск
Список
Период
Сортировка
От Jeff Frost
Тема Re: Postgres Replaying WAL slowly
Дата
Msg-id 571D044B-260A-4E06-ACBC-8869B8F73C0F@pgexperts.com
обсуждение исходный текст
Ответ на Re: Postgres Replaying WAL slowly  (Jeff Frost <jeff@pgexperts.com>)
Ответы Re: Postgres Replaying WAL slowly  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-performance

On Jun 30, 2014, at 1:46 PM, Jeff Frost <jeff@pgexperts.com> wrote:

So it seems like we have a candidate explanation.  I'm a bit surprised
that StandbyReleaseLocks would get this slow if there are only a dozen
AccessExclusiveLocks in place at any one time, though.  Perhaps that
was a low point and there are often many more?



Entirely possible that it was a low point.  We'll set up some monitoring to track the number of AccessExclusiveLocks and see how much variance there is throughout the day.


Since we turned on the monitoring for that, we had a peak of 13,550 AccessExclusiveLocks.  So far most of the samples have been in the double digit, with that and two other outliers: 6,118 and 12,747.

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

Предыдущее
От: Jeff Frost
Дата:
Сообщение: Re: Postgres Replaying WAL slowly
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Postgres Replaying WAL slowly