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