Sibte Abbas napisał(a): > On 6/20/07, Ireneusz Pluta < ipluta@wp.pl> wrote: >> Hello, >> >> How can I make sure that autovacuum is running, beyond believing that >> all autovacuum_ settings in >> postgresql.conf are set correctly? >> >> In the 8.1 I could see: >> LOG: autovacuum: processing database "test" >> in the log. >> >> But I can't find it in the 8.2.4. >> >> I could see some developers discussions about making changes to >> logging autovacuum activity, however >> could not track the discussion tight enough to find what the final >> solution is. >> >> Thanks >> >> Ireneusz Pluta >> >> > > ps -ef | grep autovacuum. > It does not show it. I run freebsd, does it matter?
Anyway, I found that I may enable logging autovacuum messages by setting:
log_min_messages = debug1
in postgresql.conf
I found it from postgresql-8.2.4/src/backend/postmaster/autovacuum.c, where I read in line 420: