Re: Problem with 8.4 stats collector high load

Tom Lane wrote:
> Alvaro Herrera <alvherre@commandprompt.com> writes:
> > Jakub Ouhrabka wrote:
> >> Was autovacuum requesting to write this 20MB file 650x per minute?
> 
> > Yes, exactly.
> 
> > Ideally, autovacuum would only request a new copy of the file if the one
> > it got was considerably out of date.  Obviously a tenth of a second is
> > not old enough.
> 
> Wasn't it you that insisted on a short staleness criterion for autovac
> in the first place?

well, my current opinion is that we should spend some nonzero amount of
thought into figuring out what to do.

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.