Re: Vacuumdb - Mailing list pgsql-admin

From A.Bhuvaneswaran
Subject Re: Vacuumdb
Date
Msg-id Pine.LNX.4.44.0304031041250.1157-100000@Bhuvan.bksys.co.in
Whole thread Raw
In response to Vacuumdb  (Raquel Vieira <raquel.vieira@ent.efacec.pt>)
Responses Re: Vacuumdb
List pgsql-admin
> 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.

regards,
bhuvaneswaran


pgsql-admin by date:

Previous
From: Murthy Kambhampaty
Date:
Subject: Re: LVM snapshots
Next
From: "Nathalie Boulos"
Date:
Subject: Re: Import/export CSV files to postgres