Re: Displaying accumulated autovacuum cost - Mailing list pgsql-hackers

From Greg Smith
Subject Re: Displaying accumulated autovacuum cost
Date
Msg-id 4E8C00F4.9040000@2ndQuadrant.com
Whole thread Raw
In response to Re: Displaying accumulated autovacuum cost  (Alvaro Herrera <alvherre@commandprompt.com>)
Responses Re: Displaying accumulated autovacuum cost
Re: Displaying accumulated autovacuum cost
List pgsql-hackers
On 09/29/2011 10:40 AM, Alvaro Herrera wrote:
> I reviewed this patch.  My question for you is: does it make sense to
> enable to reporting of write rate even when vacuum cost accounting is
> enabled?  In my opinion it would be useful to do so.  If you agree,
> please submit an updated patch.
>    

Presumably you meant to ask if this makes sense to show when cost 
accounting isn't enabled, because the code doesn't do that right now.  
No cost accounting, no buffer usage/write rate data as this was submitted.

Looks like making this work even in cases where cost accounting isn't on 
will make the patch a bit larger obtrusive, but it's not unreasonable.  
Now that you mention it, people who do a manual, full-speed VACUUM would 
certainly appreciate some feedback on the rate it ran at.  I'll include 
that in the next update.

-- 
Greg Smith   2ndQuadrant US    greg@2ndQuadrant.com   Baltimore, MD
PostgreSQL Training, Services, and 24x7 Support  www.2ndQuadrant.us



pgsql-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: Re: Separating bgwriter and checkpointer
Next
From: Heikki Linnakangas
Date:
Subject: Re: Double sorting split patch