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

Re: Memory Settings....

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: <pgsql-performance(at)postgresql(dot)org>,"Lee Keel" <lee(dot)keel(at)uai(dot)com>
Subject: Re: Memory Settings....
Date: 2007-10-22 17:34:06
Message-ID: 471C98BD.EE98.0025.0@wicourts.gov (view raw or flat)
Thread:
Lists: pgsql-performance
>>> On Mon, Oct 22, 2007 at 11:10 AM, in message
<76758090F8686C47A44B6FF52514A1D30904E0B5(at)hermes(dot)uai(dot)int>, Lee Keel
<lee(dot)keel(at)uai(dot)com> wrote: 

> there will probably be no more than 50 simultaneous requests.

> Dual-Quad Core 2.33GHz

My benchmarks have indicated that you want to keep the number of
active queries at or below four times the number of CPUs.  You might
want to consider some form of connection pooling which can queue the
requests to achieve that.  It can boost both the throughput and the
response time.
 
-Kevin
 



In response to

pgsql-performance by date

Next:From: Adrian DemaestriDate: 2007-10-23 02:24:39
Subject: Seqscan
Previous:From: Heikki LinnakangasDate: 2007-10-22 17:30:18
Subject: Re: Memory Settings....

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