Alvaro Herrera <alvherre(at)commandprompt(dot)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
In response to
pgsql-hackers by date
|Next:||From: Alvaro Herrera||Date: 2010-02-16 23:12:30|
|Subject: Re: Problem with 8.4 stats collector high load|
|Previous:||From: David E. Wheeler||Date: 2010-02-16 23:04:37|
|Subject: Re: PostgreSQL::PLPerl::Call - Simple interface for calling SQL functions from PostgreSQL PL/Perl |