Re: AutoVacuum starvation from sinval messages

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: AutoVacuum starvation from sinval messages
Дата
Msg-id 21893.1352417026@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: AutoVacuum starvation from sinval messages  (Simon Riggs <simon@2ndQuadrant.com>)
Ответы Re: AutoVacuum starvation from sinval messages  (Robert Haas <robertmhaas@gmail.com>)
Список pgsql-hackers
Simon Riggs <simon@2ndQuadrant.com> writes:
> On 8 November 2012 20:36, Jeff Janes <jeff.janes@gmail.com> wrote:
>> It does not seem outrageous to me that there would be real-world
>> conditions in which invalidations would be sent more than once a
>> minute over prolonged periods, so this total starvation seems like a
>> bug.

> Yes, its a bug, but do you really believe the above? In what cases?

It doesn't take a whole lot of DDL to provoke an sinval overrun, if
the recipient process is just sitting idle and not servicing the
messages.  I think Jeff's concern is entirely valid.
        regards, tom lane



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

Предыдущее
От: Hannu Krosing
Дата:
Сообщение: Re: TRUNCATE SERIALIZABLE and frozen COPY
Следующее
От: Jeff Janes
Дата:
Сообщение: Re: Further pg_upgrade analysis for many tables