On Tue, Aug 07, 2007 at 11:59:03AM -0700, Andrew Hammond wrote:
> On 8/7/07, Tom Lane <[EMAIL PROTECTED]> wrote:
> >
> > Peter Eisentraut <[EMAIL PROTECTED]> writes:
> > > But INFO is not shown by default.
> >
> > INFO is mostly a hack to try to emulate VACUUM VERBOSE's ancient
> > behavior before we redesigned the elog levels.  It's intended for
> > controlling messages that should go to a client because the client
> > asked for them, and usually should NOT go to the log.  I think it's
> > 100% inappropriate to use it for messages from a background process
> > that has no client.
> >
> Traditional log-level semantics aren't very rich. I think that's the real
> source of this problem: "How do I get the info I need to tune auto-vacuum
> without swamping my system with log IO". While the following isn't
> production ready, it seems to have some really good ideas.

Is logging really the answer for that? ISTM it'd be better to provide
statistics info so that you could monitor autovacuum activity with
things like cricket, SNMP, etc.
Decibel!, aka Jim Nasby                        [EMAIL PROTECTED]
EnterpriseDB      http://enterprisedb.com      512.569.9461 (cell)

Attachment: pgpQAGIJLuS1i.pgp
Description: PGP signature

Reply via email to