X-Original-To: pgsql-admin@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id F2D86475CE5 for ; Thu, 3 Apr 2003 14:22:56 -0500 (EST) Received: from localhost.localdomain (unknown [65.217.53.66]) by postgresql.org (Postfix) with ESMTP id D3C96475B47 for ; Thu, 3 Apr 2003 14:22:55 -0500 (EST) Received: from thorn.mmrd.com (thorn.mmrd.com [172.25.10.100]) by localhost.localdomain (8.12.8/8.12.5) with ESMTP id h33Jxlkj018376; Thu, 3 Apr 2003 14:59:47 -0500 Received: from gnvex001.mmrd.com (gnvex001.mmrd.com [192.168.3.55]) by thorn.mmrd.com (8.11.6/8.11.6) with ESMTP id h33JMex12280; Thu, 3 Apr 2003 14:22:40 -0500 Received: from camel.mmrd.com ([172.25.5.213]) by gnvex001.mmrd.com with SMTP (Microsoft Exchange Internet Mail Service Version 5.5.2653.13) id F3HTLYXS; Thu, 3 Apr 2003 14:22:39 -0500 Subject: Re: Vacuumdb From: Robert Treat To: "A.Bhuvaneswaran" Cc: Raquel Vieira , pgsql-admin@postgresql.org In-Reply-To: References: Content-Type: text/plain Content-Transfer-Encoding: 7bit X-Mailer: Ximian Evolution 1.0.8 Date: 03 Apr 2003 14:22:40 -0500 Message-Id: <1049397760.13799.5274.camel@camel> Mime-Version: 1.0 X-Spam-Status: No, hits=-38.0 required=5.0 tests=BAYES_10,EMAIL_ATTRIBUTION,IN_REP_TO,QUOTED_EMAIL_TEXT, REFERENCES,REPLY_WITH_QUOTES,USER_AGENT_XIMIAN autolearn=ham version=2.50 X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp) X-Archive-Number: 200304/43 X-Sequence-Number: 8198 On Thu, 2003-04-03 at 00:13, A.Bhuvaneswaran wrote: > > I'm using PostgreSQL 7.0.3. > > I'm doing vacuumdb in my database every night to repair it. But now I have a > > problem. I'm looking in /var/lib/pgsql/data/base/ for the tables length and > > the primary keys of the tables are not cleaned and is increasing evey day. > > What can I do to clean it? > > Thank you for the help. > > If you mean hard disk space consumption, you might have to run vacuum > full. > Actually the vacuum in 7.0.3 is a vacuum full. I'm guessing the problem is really index bloat, try dropping and recreating some of your indexes. After that you need to seriously look at upgrading. Robert Treat