Horton

Re: BUG #4020: RFE: have way to log autovacuum activity

Alvaro Herrera <alvherre@commandprompt.com>

View thread
From: Alvaro Herrera <alvherre@commandprompt.com>
To: Joseph S <jks@selectacast.net>
Cc: pgsql-bugs@postgresql.org
Date: 2008-03-10T15:25:06Z
Lists: pgsql-bugs 
Joseph S wrote:
> Alvaro Herrera wrote:
>
>> Yeah, we have a configurable autovacuum log on 8.3.
>>
> Sorry, I looked but didn't see it.

#log_autovacuum_min_duration = -1   # -1 disables, 0 logs all actions and
                    # their durations, > 0 logs only
                    # actions running at least that time.

We don't log "start of action" though ...

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.