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