Re: Autovacuum on by default?

Alvaro Herrera wrote:
> Bruce Momjian wrote:
> > Matthew T. O'Connor wrote:
> > > Bruce Momjian wrote:
> > > > Matthew T. O'Connor wrote:
> > > >
> > > >> and increasing the log level when autovacuum actually fires off a VACUUM
> > > >> or ANALYZE command.
> > > >>
> > > >
> > > > This was not done because the logging control only for autovacuum was
> > > > going to be added. Right now, if you want to see the vacuum activity,
> > > > you end up seeing debug stuff too (very ugly).
> > >
> > > Any chance we can make this change before release? I think it's very
> > > important to be able to look through the logs and *know* that you tables
> > > are getting vacuumed or not.
> >
> > 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.
>
> Well, the problem is that it shows what it's *currently* doing, but it
> doesn't let you know what has happened in the last day or whatever. It
> can't answer "has table foo been vacuumed recently?" or "what tables
> haven't been vacuumed at all during this week?"

True, but it seems strange to use the server logs for this type of
information. If anything, perhaps we should allow an optional file name
to put that information, or update pg_class with the most recent vacuum
time, or even better append that information to a system table.

--
Bruce Momjian bruce(at)momjian(dot)us
EnterpriseDB http://www.enterprisedb.com

+ If your life is a hard drive, Christ can be your backup. +