Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 8F85A64FF13 for ; Mon, 22 Dec 2008 11:27:54 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 38364-09 for ; Mon, 22 Dec 2008 11:27:39 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from gwmta.wicourts.gov (gwmta.wicourts.gov [165.219.244.99]) by mail.postgresql.org (Postfix) with ESMTP id B214B64FD08 for ; Mon, 22 Dec 2008 11:27:39 -0400 (AST) Received: from Courts-MTA by gwmta.wicourts.gov with Novell_GroupWise; Mon, 22 Dec 2008 09:27:37 -0600 Message-Id: <494F5D81.EE98.0025.0@wicourts.gov> X-Mailer: Novell GroupWise Internet Agent 7.0.3 Date: Mon, 22 Dec 2008 09:27:29 -0600 From: "Kevin Grittner" To: "Mark Wong" , "pgsql-performance@postgresql.org" Cc: "Gabrielle Roth" , "Selena Deckelmann" Subject: Re: dbt-2 tuning results with postgresql-8.3.5 References: <70c01d1d0812201654i5f55150ep619a6c7ff094470@mail.gmail.com> In-Reply-To: <70c01d1d0812201654i5f55150ep619a6c7ff094470@mail.gmail.com> Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit Content-Disposition: inline X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200812/195 X-Sequence-Number: 32231 >>> "Mark Wong" wrote: > The DL380 G5 is an 8 core Xeon E5405 with 32GB of > memory. The MSA70 is a 25-disk 15,000 RPM SAS array, currently > configured as a 25-disk RAID-0 array. > number of connections (250): > Moving forward, what other parameters (or combinations of) do people > feel would be valuable to illustrate with this workload? To configure PostgreSQL for OLTP on that hardware, I would strongly recommend the use of a connection pool which queues requests above some limit on concurrent queries. My guess is that you'll see best results with a limit somewhere aound 40, based on my tests indicating that performance drops off above (cpucount * 2) + spindlecount. I wouldn't consider tests of the other parameters as being very useful before tuning this. This is more or less equivalent to the "engines" configuration in Sybase, for example. -Kevin