Re: Problem with 8.4 stats collector high load

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?
        regards, tom lane