Jeff Boes <[EMAIL PROTECTED]> writes: > On Thu, 2003-06-12 at 12:42, Tom Lane wrote: >> How often do you VACUUM?
> We've gone from daily, to twice daily, to several times during the "peak > updates" period, and back to twice daily. I suspect that the real problem here is the old open transactions discussed in your other message. Those are preventing VACUUM from reclaiming space. Now that you've got that fixed, you need to revisit your experiments about how often to VACUUM. > We're also ANALYZE-ing the largest 12-18 tables on a cycle: every twenty > minutes, a daemon wakes up and ANALYZEs until they're all done or two > minutes has elapsed, whichever comes first. That sounds a tad excessive; are the statistics really changing that fast? regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster