Re: Logging pg_autovacuum

Uh, while you are at it, the background writer and checkpoint operations
need similar treatment. :-)

---------------------------------------------------------------------------

Larry Rosenman wrote:
> Tom Lane wrote:
> > "Larry Rosenman" <lrosenman(at)pervasive(dot)com> writes:
> >> I'd like to see a more concrete definition of what we
> >> want Autovacuum to output and at what levels.
> >
> > I would argue that what people typically want is
> >
> > (0) nothing
> >
> > (1) per-database log messages
> >
> > or
> >
> > (2) per-table log messages (including per-database)
> >
> > The first problem is that (2) is only available at DEBUG2 or below,
> > which is not good because that also clutters the log with a whole lot
> > of implementer-level debugging info.
> >
> > The second problem is that we don't really want to use the global
> > log_min_messages setting to determine this, because that constrains
> > your decision about how much chatter you want from ordinary backends.
> >
> > I suggest that maybe the cleanest solution is to not use log level at
> > all for this, but to invent a separate "autovacuum_verbosity" setting
> > that controls how many messages autovac tries to log, using the above
> > scale. Anything it does try to log can just come out at LOG message
> > setting.
>
> This sounds like a winner to me. Anyone else want to grab it? I'm
> in the position to try and do this, but don't want to step on anyone
> else's toes.
>
> LER
>
> >
> > regards, tom lane
>
>
>
> --
> Larry Rosenman
> Database Support Engineer
>
> PERVASIVE SOFTWARE. INC.
> 12365B RIATA TRACE PKWY
> 3015
> AUSTIN TX 78727-6531
>
> Tel: 512.231.6173
> Fax: 512.231.6597
> Email: Larry(dot)Rosenman(at)pervasive(dot)com
> Web: www.pervasive.com
>

--
Bruce Momjian http://candle.pha.pa.us
EnterpriseDB http://www.enterprisedb.com

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