Re: BUG #4020: RFE: have way to log autovacuum activity - Mailing list pgsql-bugs

From Alvaro Herrera
Subject Re: BUG #4020: RFE: have way to log autovacuum activity
Date
Msg-id 20080307214332.GC16862@alvh.no-ip.org
Whole thread Raw
In response to BUG #4020: RFE: have way to log autovacuum activity  ("Joseph S" <jks@selectacast.net>)
Responses Re: BUG #4020: RFE: have way to log autovacuum activity
List 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

pgsql-bugs by date:

Previous
From: "Joseph S"
Date:
Subject: BUG #4020: RFE: have way to log autovacuum activity
Next
From: "Yann ROBIN"
Date:
Subject: BUG #4021: UUID NULL and not equal query failed