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: (view raw, whole thread or download thread mbox)
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.


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-2017 The PostgreSQL Global Development Group