Bruce Momjian <[EMAIL PROTECTED]> writes: > What is the advantage of delaying vacuum per page vs. just doing vacuum > less frequently?
The point is the amount of load VACUUM poses while it's running. If your setup doesn't have a lot of disk bandwidth to spare, a background VACUUM can hurt the performance of your foreground applications quite a bit. Running it less often doesn't improve this issue at all. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly