Re: Auto vacuum - Mailing list pgsql-admin

From Tom Lane
Subject Re: Auto vacuum
Date
Msg-id 12357.1176841845@sss.pgh.pa.us
Whole thread Raw
In response to Re: Auto vacuum  (Carol Walter <walterc@indiana.edu>)
Responses Re: Auto vacuum
List pgsql-admin
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

pgsql-admin by date:

Previous
From: Carol Walter
Date:
Subject: Re: Auto vacuum
Next
From: "Diego de Lima"
Date:
Subject: Hiding databases from roles