From: Matthew T. O'Connor <matthew@zeut.net>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Joe Maldonado <joe.maldonado@gmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: autovacuum daemon question...
Date: Wed, 09 Nov 2005 17:46:54 -0500
Message-ID: <43727C5E.7090501@zeut.net> (raw)
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>
Tom Lane wrote:
> 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).
While I personally think this would probably be a good idea, I also
recognize that it might be a solution in search of a problem. Now that
we have integrated autovacuum we should probably wait and see what
feedback we get from the field. That said, my argument for more
detailed logging of autovacuum activity is that vacuuming is VERY
important part of proper PG maintenance, as such lots of admins like to
keep a proactive eye to make sure there tables are getting the
maintenance they need.
Another thought: How about adding something to the stats system that an
admin can turn on / off. Maybe anew relation called
pg_stat_autovacuum_activity this would detail the last vacuum, last
analyze, number of vacuums / analyzes in the last 24 hours, last month
etc... I dunno, whatever peopel think is relevant.
Thoughts?
Matt
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: matthew@zeut.net, tgl@sss.pgh.pa.us, joe.maldonado@gmail.com
Subject: Re: autovacuum daemon question...
In-Reply-To: <43727C5E.7090501@zeut.net>
References: <824355640511090720l27eabde8r61573e574f4904ab@mail.gmail.com> <437227FA.9020502@tocr.com> <824355640511091134t7123bb51sf759391f68c1590f@mail.gmail.com> <19439.1131571556@sss.pgh.pa.us> <43727C5E.7090501@zeut.net>
* 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