Re: Displaying accumulated autovacuum cost

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