Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group