Tom Lane wrote:
> Bruce Momjian <bruce@momjian.us> writes:
> > Agreed. I just IM'ed Alvaro and he says pg_stat_activity should now
> > show exactly what autovacuum is doing (and if it doesn't, let's fix it).
> > I think that is the best solution to the monitoring problem, rather than
> > throwing lines in the server logs.
>
> How do you figure that? The point of logging what's done is so that you
> can find out what autovac has been doing, not what it's doing right now.
I don't think the server logs is the place to record history autovacuum
activity. I am not saying we might not need that functionality, but not
in the server logs, and I think others seem to agree.
-- Bruce Momjian bruce@momjian.us EnterpriseDB http://www.enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +