Postgres Pro
Downloads
Home   >   mailing lists

Re: does vacuum still lock the table? - Mailing list pgsql-general

From Tom Lane
Subject Re: does vacuum still lock the table?
Date
Msg-id 28544.1048315072@sss.pgh.pa.us
Whole thread Raw
In response to does vacuum still lock the table?  (charette@writeme.com (Stephane Charette))
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: "Ed L."
Date:
Subject: Re: 32/64-bit transaction IDs?
Next
From: Martijn van Oosterhout
Date:
Subject: Re: Please clarify with regard to Renaming a Sequence