X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id BFF56329CD2 for ; Thu, 16 Sep 2004 23:37:32 +0100 (BST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 17759-05 for ; Thu, 16 Sep 2004 22:37:21 +0000 (GMT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by svr1.postgresql.org (Postfix) with ESMTP id 9AC5E329CBC for ; Thu, 16 Sep 2004 23:37:22 +0100 (BST) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.12.9/8.12.9) with ESMTP id i8GMbJCn020358 for ; Thu, 16 Sep 2004 22:37:19 GMT (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.12.9/8.12.9/Submit) id i8GMOUiM016406 for pgsql-admin@postgresql.org; Thu, 16 Sep 2004 22:24:30 GMT From: Gaetano Mendola X-Newsgroups: comp.databases.postgresql.admin Subject: Re: VACUUM FULL achieves nothing / Postgres 7.3.2 + RedHat 7.3 Date: Fri, 17 Sep 2004 00:24:22 +0200 Organization: PYRENET Midi-pyrenees Provider Lines: 35 Message-ID: <414A1296.2020702@bigfoot.com> References: <41484EA5.9060904@bigfoot.com> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Complaints-To: abuse@pyrenet.fr To: "R. Willmington" User-Agent: Mozilla Thunderbird 0.8 (Windows/20040913) X-Accept-Language: en-us, en In-Reply-To: X-Enigmail-Version: 0.86.1.0 X-Enigmail-Supports: pgp-inline, pgp-mime To: pgsql-admin@postgresql.org X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200409/153 X-Sequence-Number: 14856 R. Willmington wrote: > Gaetano Mendola wrote in message news:<41484EA5.9060904@bigfoot.com>... > > >>Are you sure you dont have connection in status: "idle in transaction"? >>Check with: >> >>ps -eafwww | grep post >> >> >>Gaetano > > > Hello Gaetano, > > Thank you for the reply. > I have checked the connections with the command you suggested, they > are all in status "idle". > > Update on the problem described in my initial posting: > > I have deleted some 4000 records from the table on the live system in > the meantime, it took about 36 minutes to complete. Do you have cascade delete ? 4000 record in 36 minutes are too much, in my system I delete milion records in a few seconds, are you sure you are presenting the entire scenario ? Regards Gaetano Mendola