PG 7.2 on Linux: where's the space?

From: jboes(at)nexcerpt(dot)com (Jeff Boes)
To: pgsql-admin(at)postgresql(dot)org
Subject: PG 7.2 on Linux: where's the space?
Date: 2002-08-23 17:41:53
Message-ID: d40a65a1.0208230941.74dbc9e6@posting.google.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Chad R. Larson 2002-08-23 18:03:36 Re: 64 Bit build for Sparc
Previous Message Bruce Momjian 2002-08-23 17:29:57 Re: Passwords and batch processes (was Re: Problem with