X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 89D9A9DC801 for ; Tue, 24 Jan 2006 17:00:41 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 36312-05 for ; Tue, 24 Jan 2006 17:00:41 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from r1.mycybernet.net (r1.mycybernet.net [209.5.206.8]) by postgresql.org (Postfix) with ESMTP id EF32B9DC81A for ; Tue, 24 Jan 2006 17:00:38 -0400 (AST) Received: from 227-54-222-209.mycybernet.net ([209.222.54.227]:36197 helo=phlogiston.dydns.org) by r1.mycybernet.net with esmtp (Exim 4.50 (FreeBSD)) id 1F1VHJ-000BtZ-Vd for pgsql-performance@postgresql.org; Tue, 24 Jan 2006 16:00:38 -0500 Received: by phlogiston.dydns.org (Postfix, from userid 1000) id 279194069; Tue, 24 Jan 2006 16:00:37 -0500 (EST) Date: Tue, 24 Jan 2006 16:00:37 -0500 From: Andrew Sullivan To: pgsql-performance@postgresql.org Subject: Re: Investigating IO Saturation Message-ID: <20060124210037.GF7199@phlogiston.dyndns.org> References: <43D65736.9020905@ca.afilias.info> <19963.1138122458@sss.pgh.pa.us> <60oe21o1hc.fsf@dba2.int.libertyrms.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <60oe21o1hc.fsf@dba2.int.libertyrms.com> User-Agent: Mutt/1.5.9i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.079 required=5 tests=[AWL=0.079] X-Spam-Score: 0.079 X-Spam-Level: X-Archive-Number: 200601/423 X-Sequence-Number: 16901 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