From: Kevin Grittner <Kevin.Grittner@wicourts.gov>
To: pgsql-performance@postgresql.org
To: Lee Keel <lee.keel@uai.com>
Subject: Re: Memory Settings....
Date: Mon, 22 Oct 2007 12:34:06 -0500
Message-ID: <471C98BD.EE98.0025.0@wicourts.gov> (raw)
In-Reply-To: <76758090F8686C47A44B6FF52514A1D30904E0B5@hermes.uai.int>
References: <76758090F8686C47A44B6FF52514A1D30904E0B5@hermes.uai.int>
>>> 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: Kevin.Grittner@wicourts.gov, lee.keel@uai.com
Subject: Re: Memory Settings....
In-Reply-To: <471C98BD.EE98.0025.0@wicourts.gov>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox