Re: Very busy 24x7 databases and VACUUM

On Sun, Dec 05, 2004 at 11:18:47PM -0500, Christopher Browne wrote:
> One thing that would be somewhat helpful would be to be sure that each
> of the tables that you are vacuuming is handled in a separate
> transaction.

What Chris said.  In particular, I've found that pg_autovacuum has
the ability really to kill performance if it starts at the wrong
moment.  You need something much more hand-crafted at the moment.
I'll bet, however, that vacuuming some tables more often than once a
day will still be a net win for you.

A
--
Andrew Sullivan  | ajs@crankycanuck.ca
This work was visionary and imaginative, and goes to show that visionary
and imaginative work need not end up well.
        --Dennis Ritchie