Re: Vacuumdb

From: "A(dot)Bhuvaneswaran" <bhuvansql(at)myrealbox(dot)com>
To: Raquel Vieira <raquel(dot)vieira(at)ent(dot)efacec(dot)pt>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Vacuumdb
Date: 2003-04-03 05:13:42
Message-ID: Pine.LNX.4.44.0304031041250.1157-100000@Bhuvan.bksys.co.in
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

  • Vacuumdb at 2003-04-02 15:51:00 from Raquel Vieira

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Nathalie Boulos 2003-04-03 08:10:29 Re: Import/export CSV files to postgres
Previous Message Murthy Kambhampaty 2003-04-03 00:21:18 Re: LVM snapshots