Re: VACUUM FULL and ALTER TABLE do *nothing* in 7.3.2

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "SZUCS Gabor" <surrano(at)mailbox(dot)hu>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: VACUUM FULL and ALTER TABLE do *nothing* in 7.3.2
Date: 2003-05-06 14:35:04
Message-ID: 25098.1052231704@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

"SZUCS Gabor" <surrano(at)mailbox(dot)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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Achilleus Mantzios 2003-05-06 15:01:04 Re: Problem with Attribute.
Previous Message Stephan Szabo 2003-05-06 14:32:45 Re: VACUUM FULL and ALTER TABLE do *nothing* in 7.3.2