"D Kavan" <[EMAIL PROTECTED]> writes:
> Even though I run vacuumdb -a -f every night with no exceptions or problems,
> my database size remains 5.6 GB. After I do a dump/restore, the new
> database size is 4.0 GB. How could that be possible?
The extra 1.6GB probably represents the amount of junk you generate in
one day. So, forget the -f and instead do plain vacuums on a more
frequent basis. Make sure your FSM settings are large enough, too.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
