Re: Memory Settings.... - Mailing list pgsql-performance

From Kevin Grittner
Subject Re: Memory Settings....
Date
Msg-id 471C98BD.EE98.0025.0@wicourts.gov
Whole thread Raw
In response to Memory Settings....  (Lee Keel <lee.keel@uai.com>)
List pgsql-performance
>>> On Mon, Oct 22, 2007 at 11:10 AM, in message
<76758090F8686C47A44B6FF52514A1D30904E0B5@hermes.uai.int>, Lee Keel
<lee.keel@uai.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




pgsql-performance by date:

Previous
From: "Heikki Linnakangas"
Date:
Subject: Re: Memory Settings....
Next
From: Adrian Demaestri
Date:
Subject: Seqscan