PG 7.2 on Linux: where's the space? - Mailing list pgsql-admin

From jboes@nexcerpt.com (Jeff Boes)
Subject PG 7.2 on Linux: where's the space?
Date
Msg-id d40a65a1.0208230941.74dbc9e6@posting.google.com
Whole thread Raw
List pgsql-admin
We upgraded from 7.1 to 7.2 recently, and saw the used space on our
database partition drop from something like 80% to under 20% (as
measured by 'du').  Hurrah!  However, it's about four weeks later and
we're back to over 80% again.  Is the solution:

1) More frequent VACUUM FULL operations?

2) REINDEX our biggest tables?

3) Periodicly dump and reload our biggest tables?

I'm really hoping this last one is not the answer, as we'd have to
take the system offline for hours every week to accomplish this.

pgsql-admin by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Passwords and batch processes (was Re: Problem with
Next
From: "Chad R. Larson"
Date:
Subject: Re: 64 Bit build for Sparc