Re: Still confused about VACUUM vs. VACUUM FULL

Jeff Boes <jboes(at)nexcerpt(dot)com> 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