Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id B73DB9FB256 for ; Mon, 2 Oct 2006 16:08:40 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 60964-02 for ; Mon, 2 Oct 2006 19:08:36 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey- Received: from noel.decibel.org (noel.decibel.org [67.100.216.10]) by postgresql.org (Postfix) with ESMTP id 8FCC79FB250 for ; Mon, 2 Oct 2006 16:08:36 -0300 (ADT) Received: by noel.decibel.org (Postfix, from userid 1001) id 5B75156427; Mon, 2 Oct 2006 14:08:33 -0500 (CDT) Received: (hashcash-sendmail, from uid 1001); Mon, 2 Oct 2006 14:08:32 -0500 Date: Mon, 2 Oct 2006 14:08:32 -0500 From: "Jim C. Nasby" To: Nimesh Satam Cc: pgsql-performance@postgresql.org Subject: Re: Table not getting vaccumed. Message-ID: <20061002190831.GG81937@nasby.net> References: <965aa3ed0609300225v33a3a6d4s9b19568d75949cc3@mail.gmail.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <965aa3ed0609300225v33a3a6d4s9b19568d75949cc3@mail.gmail.com> X-Operating-System: FreeBSD 6.0-RELEASE-p4 amd64 X-Distributed: Join the Effort! http://www.distributed.net User-Agent: Mutt/1.5.11 X-Hashcash: 1:20:061002:nimesh.zedo@gmail.com::R3k5EBg/eyXyQCo7:0000000000000000 0000000000000000000000003a/Q X-Hashcash: 1:20:061002:pgsql-performance@postgresql.org::8+S9WolaV+OrTA8B:00000 0000000000000000000000009K17 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200610/11 X-Sequence-Number: 21140 On Sat, Sep 30, 2006 at 02:55:54PM +0530, Nimesh Satam wrote: > I am trying to vaccum one of the table using the following command: > > VACUUM FULL ANALYZE VERBOSE table_name; Are you sure you want to do a vacuum full? Normally, that shouldn't be required. -- Jim Nasby jim@nasby.net EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)