Re: Investigating IO Saturation - Mailing list pgsql-performance

From Andrew Sullivan
Subject Re: Investigating IO Saturation
Date
Msg-id 20060124210037.GF7199@phlogiston.dyndns.org
Whole thread Raw
In response to Re: Investigating IO Saturation  (Chris Browne <cbbrowne@acm.org>)
List pgsql-performance
On Tue, Jan 24, 2006 at 02:43:59PM -0500, Chris Browne wrote:
> I believe it's 7.4 where the cost-based vacuum parameters entered in,
> so that would, in principle, already be an option.
>
> [rummaging around...]
>
> Hmm.... There was a patch for 7.4, but it's only "standard" as of
> 8.0...

And it doesn't work very well without changes to buffering.  You need
both pieces to get it to work.

A

--
Andrew Sullivan  | ajs@crankycanuck.ca
In the future this spectacle of the middle classes shocking the avant-
garde will probably become the textbook definition of Postmodernism.
                --Brad Holland

pgsql-performance by date:

Previous
From: Chris Browne
Date:
Subject: Re: Investigating IO Saturation
Next
From: "Daniel Gish"
Date:
Subject: Inconsistant query plan