Re: AutoVacuum starvation from sinval messages

Поиск
Список
Период
Сортировка
От Robert Haas
Тема Re: AutoVacuum starvation from sinval messages
Дата
Msg-id CA+TgmoYUmv7Tt6CG-d-C-2RPjmEw+WJb8EzFvx8v0VEvLbKL0w@mail.gmail.com
обсуждение исходный текст
Ответ на Re: AutoVacuum starvation from sinval messages  (Simon Riggs <simon@2ndQuadrant.com>)
Ответы Re: AutoVacuum starvation from sinval messages  (Simon Riggs <simon@2ndQuadrant.com>)
Список pgsql-hackers
On Fri, Nov 9, 2012 at 9:02 AM, Simon Riggs <simon@2ndquadrant.com> wrote:
>> So, do we need a sinval overrun or just a sinval message to provoke
>> starvation?  The former would be bad but the latter would be really,
>> really bad.  IIRC the queue has 4K entries, and IIRC a single DDL
>> operation might provoke a couple of sinvals, but I'm thinking that
>> somebody would probably have to be creating >1024 temp tables a minute
>> to overrun the queue, which is very possible but not necessarily
>> common.  OTOH, creating 1 temp table a minute would hit a much broader
>> swath of users.
>
> The point is moot because latches don't work that way anymore.

One of us is confused, because IIUC Tom just fixed this this morning,
and I'm trying to figure out how many users will be affected by it,
and how seriously.  Like, do we need an immediate minor release?

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company



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

Предыдущее
От: Simon Riggs
Дата:
Сообщение: Re: AutoVacuum starvation from sinval messages
Следующее
От: Simon Riggs
Дата:
Сообщение: Re: TRUNCATE SERIALIZABLE and frozen COPY