Re: Very long COMMIT times?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Very long COMMIT times?
Дата
Msg-id 29258.1005608607@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Very long COMMIT times?  ("Jeff Boes" <jboes@nexcerpt.com>)
Список pgsql-admin
"Jeff Boes" <jboes@nexcerpt.com> writes:
>> Did this come about because of the increase in WAL count?

No.

> Oops.  This turns out not to be a COMMIT time, but instead it's happening
> in a NOTIFY operation just after the COMMIT.  What would cause a
> previously-quick NOTIFY step to become many minutes long?

Have you vacuumed pg_listener recently?

            regards, tom lane

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

Предыдущее
От: "Jeff Boes"
Дата:
Сообщение: Re: Very long COMMIT times?
Следующее
От: "Peter Darley"
Дата:
Сообщение: Postgresql optimization