Re: Investigating IO Saturation

From: Andrew Sullivan <ajs(at)crankycanuck(dot)ca>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Investigating IO Saturation
Date: 2006-01-24 21:00:37
Message-ID: 20060124210037.GF7199@phlogiston.dyndns.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)crankycanuck(dot)ca
In the future this spectacle of the middle classes shocking the avant-
garde will probably become the textbook definition of Postmodernism.
--Brad Holland

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Daniel Gish 2006-01-24 23:15:57 Inconsistant query plan
Previous Message Chris Browne 2006-01-24 19:43:59 Re: Investigating IO Saturation