X-Original-To: pgsql-sql@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 5987E476516 for ; Tue, 6 May 2003 09:52:06 -0400 (EDT) Received: from mail.deltav.hu (mail.deltav.hu [213.163.0.192]) by postgresql.org (Postfix) with ESMTP id 5320F47650D for ; Tue, 6 May 2003 09:52:03 -0400 (EDT) Received: from fejleszt2 ([213.163.10.103]) by mail.deltav.hu (Netscape Messaging Server 3.6) with SMTP id AAA13C2 for ; Tue, 6 May 2003 15:52:06 +0200 Message-ID: <008801c313d6$ad89e390$0a03a8c0@fejleszt2> From: "SZUCS Gabor" To: References: Subject: Re: VACUUM FULL and ALTER TABLE do *nothing* in 7.3.2 Date: Tue, 6 May 2003 15:52:04 +0200 MIME-Version: 1.0 Content-Type: text/plain; charset="ISO-8859-7" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1106 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 X-Spam-Status: No, hits=-15.9 required=5.0 tests=BAYES_20,ORIGINAL_MESSAGE,REFERENCES 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/86 X-Sequence-Number: 13251 Dear Achilleus, Dunno, it's a multiuser environment. However, I'll try asking everyone to stop working for a minute... ... oops, I just see that it finished about half an hour before (taking an amazing 76 minutes for ALTER TABLE to complete). About that time, I started and exited a client. Seems it solved the problem. Now "vacuum full analyze" finished in a couple of seconds. Do you have any idea about an explanation? Does vacuum wait for the end of each and every transaction? G. -- while (!asleep()) sheep++; ---------------------------- cut here ------------------------------ ----- Original Message ----- From: "Achilleus Mantzios" Sent: Tuesday, May 06, 2003 7:53 PM Maybe its a locking issue. Did you quit any app using the DB? Did you commit/rollback all pending transactions (if any)?