Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group