From: Tom Lane <tgl@sss.pgh.pa.us>
To: Joe Maldonado <joe.maldonado@gmail.com>
Cc: Matthew T. O'Connor <matthew@tocr.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: autovacuum daemon question...
Date: Wed, 09 Nov 2005 16:25:56 -0500
Message-ID: <19439.1131571556@sss.pgh.pa.us> (raw)
In-Reply-To: <824355640511091134t7123bb51sf759391f68c1590f@mail.gmail.com>
References: <824355640511090720l27eabde8r61573e574f4904ab@mail.gmail.com>
<437227FA.9020502@tocr.com>
<824355640511091134t7123bb51sf759391f68c1590f@mail.gmail.com>
Joe Maldonado <joe.maldonado@gmail.com> writes:
> I agree...for now while I'm developing and debugging my application I can
> have the logging be that verbose...I agree that these should be handled as
> info messages, since they are invaluable in investigating problems.
This would be a pretty bad idea IMHO, since it would lead to bloating
the logs with autovacuum progress messages by default --- and whatever
you may think about it, I really doubt that the average DBA will want
those messages there all the time.
I wonder whether it would be practical to let the autovacuum daemon have
its own value of log_min_messages. The alternative to that seems to be
to invent a new log severity level just for autovacuum, which is pretty
gross (especially since it's not obvious how it should sort relative to
LOG and DEBUG1).
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: tgl@sss.pgh.pa.us, joe.maldonado@gmail.com, matthew@tocr.com
Subject: Re: autovacuum daemon question...
In-Reply-To: <19439.1131571556@sss.pgh.pa.us>
References: <824355640511090720l27eabde8r61573e574f4904ab@mail.gmail.com> <437227FA.9020502@tocr.com> <824355640511091134t7123bb51sf759391f68c1590f@mail.gmail.com> <19439.1131571556@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox