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

Re: dbt-2 tuning results with postgresql-8.3.5

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: "Mark Wong" <markwkm(at)gmail(dot)com>,"pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Cc: "Gabrielle Roth" <gorthx(at)gmail(dot)com>,"Selena Deckelmann" <selenamarie(at)gmail(dot)com>
Subject: Re: dbt-2 tuning results with postgresql-8.3.5
Date: 2008-12-22 15:27:29
Message-ID: (view raw or whole thread)
Lists: pgsql-performance
>>> "Mark Wong" <markwkm(at)gmail(dot)com> 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.

In response to


pgsql-performance by date

Next:From: Scott MarloweDate: 2008-12-22 18:07:24
Subject: Re: temp_tablespaces and RAID
Previous:From: Marc MaminDate: 2008-12-22 14:40:10
Subject: temp_tablespaces and RAID

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