Postgres Pro
Downloads
Home   >   mailing lists

Re: VACUUM FULL and ALTER TABLE do *nothing* in 7.3.2 - Mailing list pgsql-sql

From Tom Lane
Subject Re: VACUUM FULL and ALTER TABLE do *nothing* in 7.3.2
Date
Msg-id 25098.1052231704@sss.pgh.pa.us
Whole thread Raw
In response to Re: VACUUM FULL and ALTER TABLE do *nothing* in 7.3.2  ("SZUCS Gabor" <surrano@mailbox.hu>)
List pgsql-sql
Tree view 
"SZUCS Gabor" <surrano@mailbox.hu> writes:
> Do you have any idea about an explanation? Does vacuum wait for the end of
> each and every transaction?

VACUUM FULL needs an exclusive lock on the target table.  So does ALTER
TABLE.  So yes, it will wait for any open transaction that has accessed
the table to complete.
        regards, tom lane

pgsql-sql by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: VACUUM FULL and ALTER TABLE do *nothing* in 7.3.2
Next
From: "alexandre :: aldeia digital"
Date:
Subject: pg_stat_activity IP address