Re: pgsql: Release the exclusive lock on the table early after truncating it

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: pgsql: Release the exclusive lock on the table early after truncating it
Дата
Msg-id 1456.1189470306@sss.pgh.pa.us
обсуждение исходный текст
Ответ на pgsql: Release the exclusive lock on the table early after truncating it  (alvherre@postgresql.org (Alvaro Herrera))
Ответы Re: pgsql: Release the exclusive lock on the table early after truncating it  (Alvaro Herrera <alvherre@commandprompt.com>)
Re: pgsql: Release the exclusive lock on the table early after truncating it  (Alvaro Herrera <alvherre@commandprompt.com>)
Список pgsql-committers
Дерево обсуждения 
alvherre@postgresql.org (Alvaro Herrera) writes:
> Release the exclusive lock on the table early after truncating it in lazy
> vacuum, instead of waiting till commit.

Weren't you going to disable vacuum_delay in that stretch of code, too?

BTW, not sure if you realized this, but just deleting the
vacuum_delay_point call is probably a bad idea --- replace it
with CHECK_FOR_INTERRUPTS() instead.

            regards, tom lane

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

Предыдущее
От: tgl@postgresql.org (Tom Lane)
Дата:
Сообщение: pgsql: Arrange for SET LOCAL's effects to persist until the end of the
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: pgsql: Release the exclusive lock on the table early after truncating it