Aleksey Serba <[EMAIL PROTECTED]> writes:
> I have 24/7 production server under high load.
> I need to perform vacuum full on several tables to recover disk
> space / memory usage frequently ( the server must be online during
> vacuum time )
Don't use VACUUM FULL; plain VACUUM should be enough if you are managing
the database properly (for instance, make sure the FSM settings are high
enough).
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend
