X-Original-To: pgsql-admin@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 8D163475FD9 for ; Wed, 2 Apr 2003 10:51:58 -0500 (EST) Received: from efapo1.efacec.pt (unknown [213.58.212.81]) by postgresql.org (Postfix) with ESMTP id C5E54475EC9 for ; Wed, 2 Apr 2003 10:51:25 -0500 (EST) Received: from rvieira (172.18.56.43 [172.18.56.43]) by efapo1.efacec.pt with SMTP (Microsoft Exchange Internet Mail Service Version 5.5.2653.13) id 2DXKZ3AA; Wed, 2 Apr 2003 16:51:27 +0100 Content-Type: text/plain; charset="iso-8859-1" From: Raquel Vieira Organization: ENT To: pgsql-admin@postgresql.org Subject: Vacuumdb Date: Wed, 2 Apr 2003 16:51:00 +0100 X-Mailer: KMail [version 1.2] MIME-Version: 1.0 Message-Id: <03040216510000.31721@rvieira> Content-Transfer-Encoding: quoted-printable X-Spam-Status: No, hits=-1.6 required=5.0 tests=BAYES_30 version=2.50 X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp) X-Archive-Number: 200304/23 X-Sequence-Number: 8178 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. Raquel Vieira