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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-performance by date

  From Date Subject
Next Message Adrian Demaestri 2007-10-23 02:24:39 Seqscan
Previous Message Heikki Linnakangas 2007-10-22 17:30:18 Re: Memory Settings....