Michael Fahey <mfahey(at)winklerpartners(dot)com> writes:
> My database cluster at 22 GB is outgrowing the 30 GB partition I set
> aside for it.
> I periodically dump the cluster to a development server, but when it is
> loaded onto the development server, the cluster takes up just 145MB.
> I'm using 7.4.7-6sarge1 . I vacuum nightly and do a full vacuum weekly,
> but this doesn't seem to have any effect on size.
It's clear that you aren't vacuuming *nearly* enough for your workload.
Think about vacuuming hourly. Check your FSM settings.
regards, tom lane
In response to
pgsql-admin by date
|Next:||From: Jeff Frost||Date: 2005-08-31 05:33:22|
|Subject: auto vacuum settings|
|Previous:||From: Michael Fahey||Date: 2005-08-31 03:52:17|
|Subject: Disk Usage Problem|