Thread

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

Joseph Shraibman <jks@selectacast.net> — 2008-03-07T21:31:00Z

The following bug has been logged online:

Bug reference:      4020
Logged by:          Joseph S
Email address:      jks@selectacast.net
PostgreSQL version: 8.2.5
Operating system:   CentOS 5
Description:        RFE: have way to log autovacuum activity
Details: 

When autovacuum decides to vacuum one of our large tables, the whole site
slows down, but it is not always obvious why.  It would be nice if there was
an option to log autovacuum activity so I know how often a vacuum runs and
how long it takes.

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

Alvaro Herrera <alvherre@commandprompt.com> — 2008-03-07T21:43:32Z

Joseph S wrote:

> When autovacuum decides to vacuum one of our large tables, the whole site
> slows down, but it is not always obvious why.  It would be nice if there was
> an option to log autovacuum activity so I know how often a vacuum runs and
> how long it takes.

Yeah, we have a configurable autovacuum log on 8.3.

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

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

Joseph Shraibman <jks@selectacast.net> — 2008-03-10T14:54:21Z
```
Alvaro Herrera wrote:

> Yeah, we have a configurable autovacuum log on 8.3.
>
Sorry, I looked but didn't see it.
```

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

Alvaro Herrera <alvherre@commandprompt.com> — 2008-03-10T15:25:06Z

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.