Michael Fahey <mfahey@winklerpartners.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