Re: Problem with 8.4 stats collector high load

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

I'd suggest to do it like this:

Do autovac_refresh_stats() once per autovacuum_naptime/2 and share the 
result among all autovacuum workers.

This would guarantee that autovacuum is fired no later than 
autovacuum_naptime after the condition for the run became true.

If it's not that easy to code then don't share it among the workers and 
do it once per worker - typically there are not so many workers.

And for bigger installations document that it's highly recommend to put 
the stats file on ramdisk.

Kuba

Dne 17.2.2010 0:12, Alvaro Herrera napsal(a):
> 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.
>