Re: tuning autovacuum

Greg Smith <greg@2ndQuadrant.com> writes:
> What we'd probably need to do with those is handle them like the other 
> stats in the system:  store a total number for visited/cleaned/dead for 
> each relation, then increment the total as each vacuum finishes.

As Robert said, we're already seeing scalability problems with the
pg_stats subsystem.  I'm not eager to add a bunch more per-table
counters, at least not without some prior work to damp down the ensuing
performance hit.
        regards, tom lane