Re: Auto vacuum

Carol Walter <walterc@indiana.edu> writes:
> 8.2.3 is what is reported when I run psql with the -V option.

In 8.2 you need to increase log_min_messages to see anything about
autovacuum.  It reports per-database activity at DEBUG1 and per-table
activity at DEBUG2 level.  Unfortunately DEBUG2 will fill your log
with a lot of other chatter as well :-(.  There's work going on
right now to improve the reporting of autovac activity for 8.3.

            regards, tom lane