On Thu, 2005-11-10 at 02:04, Jeff Bohmer wrote:
> >Another thought: How about adding something to the stats system
> >that an admin can turn on / off. Maybe anew relation called
> >pg_stat_autovacuum_activity this would detail the last vacuum, last
> >analyze, number of vacuums / analyzes in the last 24 hours, last
> >month etc... I dunno, whatever peopel think is relevant.
> >
> >Thoughts?
>
>
> My 2c ...
>
> I would appreciate an easy way to keep tabs on autovacuum's activity.
> A stat table seems like a practical way to have this info readily
> available.
>
> No need to keep values across dump/reloads, right?
This sounds more and more like a good idea. I don't think there's any
need to maintain across dump/reload and / or database restart either.