Re: Problem with 8.4 stats collector high load - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Problem with 8.4 stats collector high load
Date
Msg-id 18715.1266361531@sss.pgh.pa.us
Whole thread Raw
In response to Re: Problem with 8.4 stats collector high load  (Alvaro Herrera <alvherre@commandprompt.com>)
Responses Re: Problem with 8.4 stats collector high load
List pgsql-hackers
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


pgsql-hackers by date:

Previous
From: "David E. Wheeler"
Date:
Subject: Re: PostgreSQL::PLPerl::Call - Simple interface for calling SQL functions from PostgreSQL PL/Perl
Next
From: Alvaro Herrera
Date:
Subject: Re: Problem with 8.4 stats collector high load