X-Original-To: pgsql-sql@postgresql.org
Received: from spampd.localdomain (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id 04ECE475CBC
	for <pgsql-sql@postgresql.org>; Tue,  6 May 2003 10:35:04 -0400 (EDT)
Received: from sss.pgh.pa.us (unknown [192.204.191.242])
	by postgresql.org (Postfix) with ESMTP id 780EE474E42
	for <pgsql-sql@postgresql.org>; Tue,  6 May 2003 10:35:02 -0400 (EDT)
Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1])
	by sss.pgh.pa.us (8.12.9/8.12.9) with ESMTP id h46EZ4U6025099;
	Tue, 6 May 2003 10:35:05 -0400 (EDT)
To: "SZUCS Gabor" <surrano@mailbox.hu>
Cc: pgsql-sql@postgresql.org
Subject: Re: VACUUM FULL and ALTER TABLE do *nothing* in 7.3.2 
In-reply-to: <008801c313d6$ad89e390$0a03a8c0@fejleszt2> 
References: <Pine.LNX.4.44.0305061552020.22644-100000@matrix.gatewaynet.com>
	<008801c313d6$ad89e390$0a03a8c0@fejleszt2>
Comments: In-reply-to "SZUCS Gabor" <surrano@mailbox.hu>
	message dated "Tue, 06 May 2003 15:52:04 +0200"
Date: Tue, 06 May 2003 10:35:04 -0400
Message-ID: <25098.1052231704@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
X-Spam-Status: No, hits=-29.1 required=5.0
	tests=BAYES_00,EMAIL_ATTRIBUTION,IN_REP_TO,REFERENCES,
	REPLY_WITH_QUOTES autolearn=ham	version=2.50
X-Spam-Level: 
X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp)
X-Archive-Number: 200305/89
X-Sequence-Number: 13254

"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