does vacuum still lock the table?

Поиск
Список
Период
Сортировка
От charette@writeme.com (Stephane Charette)
Тема does vacuum still lock the table?
Дата
Msg-id 1be4bb40.0303201825.6d8e970e@posting.google.com
обсуждение исходный текст
Ответы Re: does vacuum still lock the table?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
I'm reading through the "PostgreSQL 7.2 Reference Manual" to get
information on vacuum.

(Nice set of .pdf files at
http://www.ca.postgresql.org/ftpsite/doc/current/.)

What it says for FULL vacuum is:  "...and exclusively locks the
table."

I thought I remembered reading somewhere lately that the new vacuum
process no longer needs an exclusive lock on the tables for full
vacuum.  Is this the case, or was I dreaming?  Can anyone point me to
the correct document or usenet posting if this has indeed changed
recently?

Thanks,

Stéphane Charette

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

Предыдущее
От: Darren Ferguson
Дата:
Сообщение: Re: Extracting time from timestamp
Следующее
От: "Christopher Kings-Lynne"
Дата:
Сообщение: Re: [HACKERS] Extracting time from timestamp