Обсуждение: BUG #4020: RFE: have way to log autovacuum activity
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.
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
Alvaro Herrera wrote: > Yeah, we have a configurable autovacuum log on 8.3. > Sorry, I looked but didn't see it.
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.