X-Original-To: pgsql-admin@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 71961475F5F for ; Wed, 2 Apr 2003 04:49:18 -0500 (EST) Received: from efapo1.efacec.pt (unknown [213.58.212.81]) by postgresql.org (Postfix) with ESMTP id 40E25475EC9 for ; Wed, 2 Apr 2003 04:49:10 -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 2DXKZM3N; Wed, 2 Apr 2003 10:46:33 +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 10:46:17 +0100 X-Mailer: KMail [version 1.2] MIME-Version: 1.0 Message-Id: <03040210461701.24857@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/40 X-Sequence-Number: 8195 I'm using PostgreSQL 7.0.3. I'm doing vacuumdb in my database every night to repair it. But now I have = a=20 problem. I'm looking in /var/lib/pgsql/data/base/ for the tables length and= =20 the primary keys of the tables are not cleaned and is increasing evey day.= =20 What can I do to clean it? Thank you for the help. Raquel Vieira