does vacuum still lock the table?

Started by Nonameabout 23 years ago2 messagesgeneral
Jump to latest
#1Noname
charette@writeme.com

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

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Noname (#1)
Re: does vacuum still lock the table?

charette@writeme.com (Stephane Charette) writes:

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

vacuum full is old-style vacuum which gets exclusive locks.

regards, tom lane