Re: Idle in transaction ????

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Idle in transaction ????
Дата
Msg-id 19654.1005864720@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Idle in transaction ????  (wsheldah@lexmark.com)
Список pgsql-general
wsheldah@lexmark.com writes:
> If vacuum in 7.2 skips tables it can't lock,

It does not.

The real change in 7.2 is that vacuum requires only an ordinary writer's
lock on the table, not exclusive lock.  Since a write lock doesn't
conflict with read or write locks (basically it only conflicts with
schema-changing operations) we expect that vacuum will run concurrently
with most ordinary database operations.

            regards, tom lane

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

Предыдущее
От: Glenn Sullivan
Дата:
Сообщение: spectral datasets in postgresql
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Create Rule