Received: from localhost (unknown [200.46.204.184])
	by postgresql.org (Postfix) with ESMTP id 06D249F9798
	for <pgsql-performance-postgresql.org@postgresql.org>;
	Mon, 22 Oct 2007 14:34:24 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024)
	with ESMTP id 57128-02 for
	<pgsql-performance-postgresql.org@postgresql.org>;
	Mon, 22 Oct 2007 14:34:17 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.5
Received: from gwmta.wicourts.gov (gwmta.wicourts.gov [165.219.244.99])
	by postgresql.org (Postfix) with ESMTP id D209E9F9B33
	for <pgsql-performance@postgresql.org>;
	Mon, 22 Oct 2007 14:34:18 -0300 (ADT)
Received: from Courts-MTA by gwmta.wicourts.gov
	with Novell_GroupWise; Mon, 22 Oct 2007 12:34:17 -0500
Message-Id: <471C98BD.EE98.0025.0@wicourts.gov>
X-Mailer: Novell GroupWise Internet Agent 7.0.2 
Date: Mon, 22 Oct 2007 12:34:06 -0500
From: "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
To: <pgsql-performance@postgresql.org>,"Lee Keel" <lee.keel@uai.com>
Subject: Re: Memory Settings....
References: <76758090F8686C47A44B6FF52514A1D30904E0B5@hermes.uai.int>
In-Reply-To: <76758090F8686C47A44B6FF52514A1D30904E0B5@hermes.uai.int>
Mime-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200710/244
X-Sequence-Number: 27266

>>> On Mon, Oct 22, 2007 at 11:10 AM, in message
<76758090F8686C47A44B6FF52514A1D30904E0B5@hermes.uai.int>, Lee Keel
<lee.keel@uai.com> wrote:=20

> 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.
=20
-Kevin
=20