Michael Fahey <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
