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

Alvaro Herrera <alvherre@commandprompt.com>

From: Alvaro Herrera <alvherre@commandprompt.com>

To: Joseph S <jks@selectacast.net>

Cc: pgsql-bugs@postgresql.org

Date: 2008-03-07T21:43:32Z

Lists: pgsql-bugs

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