Re: BUG #1331: after update: vacuum blocks parallel to select

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: BUG #1331: after update: vacuum blocks parallel to select
Дата
Msg-id 19023.1101745634@sss.pgh.pa.us
обсуждение исходный текст
Ответ на BUG #1331: after update: vacuum blocks parallel to select  ("PostgreSQL Bugs List" <pgsql-bugs@postgresql.org>)
Список pgsql-bugs
"Enke, Michael" <michael.enke@wincor-nixdorf.com> writes:
> But the description says: vacuum can run parallel to selects.
> This is than not true.

Sure it can; but that doesn't mean there is no interlocking at all.

The issue you have is not so much that the select is running as that it
is *not* running, ie, it's stopped on a particular page.  As soon as it
moves off the modified page, the vacuum will be able to make progress.

            regards, tom lane

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: BUG #1331: after update: vacuum blocks parallel to select
Следующее
От: Tom Lane
Дата:
Сообщение: Re: BUG #1329: Bug in IF-ELSEIF-ELSE construct