Re: More logging for autovacuum

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Dimitri Fontaine wrote:
> Le mardi 07 août 2007, Tom Lane a écrit :
>> Gregory Stark <stark(at)enterprisedb(dot)com> writes:
>>> log_autovacuum_jobs - output every time a vacuum or analyze *starts*
> [...]
>>> I would also suggest raising the level of the DEBUG2 message indicating
>>> why tables were chosen or not. At least to DEBUG1 if not to INFO.
>> It's not acceptable for autovacuum to be cluttering the log by default.
>
> If I understand correctly what is proposed, the log_autovacuum_jobs option
> would allow the user to choose whether or not he wants its log cluttered by
> autovacuum. I know I'd choose to clutter them, and would prefer not having to
> choose a DEBUG loglevel to have autovacuum logs...

With 8.3 having autovacuum on by default, we really should be logging at
a mininum:

autovacuum start
autovacuum working (what am I working on but not what I am doing,
meaning we don't need tuple information etc..)
autovacuum stop

Yes, by default or at least at no level higher than INFO.

Sincerely,

Joshua D. Drake

>
> Regards,

- --

=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/

Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFGuJJIATb/zqfZUUQRApl7AJoCq85I0drgIUg1BEn/2ngrSKCQTwCgoIik
ZmLO2N/2nQLNdNJeKUwhQEo=
=nLKN
-----END PGP SIGNATURE-----