DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=message-id:date:from:to:cc:subject:references:mime-version
	:content-type:content-disposition:in-reply-to:user-agent;
	b=K0ko30R++jh3MvmDMpB5PBvScadrvGG2qaWJP2kGIoHKMAhIDNEkG4EU/TtvHGt8pf
	RKYzf4JIAx0CJHr0JJM0y5j/lGOpVzu4J7Kw53tLb7RjS/ngtsOdduXqYkDqn9aVLQXu
	bvQRQuu8XYHOT81me8v/P/SwFl9AzBdrcngmw=
Message-ID: <4c49bb81.17bb720a.42c2.1de8@mx.google.com>
Date: Fri, 23 Jul 2010 09:55:35 -0600
From: Joshua Tolley <eggyknap@gmail.com>
To: Scott Carey <scott@richrelevance.com>
Cc: Robert Haas <robertmhaas@gmail.com>,
	Craig Ringer <craig@postnewspapers.com.au>,
	Matthew Wakeling <matthew@flymine.org>,
	"pgsql-performance@postgresql.org" <pgsql-performance@postgresql.org>
Subject: Re: Pooling in Core WAS: Need help in performance tuning.
References: <4C37791C0200002500033379@gw.wicourts.gov>
	<4C37CBFB.1000800@agliodbs.com>
	<4C37EA1D.6000008@postnewspapers.com.au>
	<AANLkTimNJZlX7kFH_r0-BB_K3NGorU7BHd85SxXJbuGJ@mail.gmail.com>
	<4C38BF03.6060503@agliodbs.com> <19244.1278787866@sss.pgh.pa.us>
	<alpine.DEB.2.00.1007121044330.2534@aragorn.flymine.org>
	<4C3AF564.5030204@postnewspapers.com.au>
	<AANLkTinDgkzqf_=O+hk5OMq+AxN4G+fpfQZM4DBizAOF@mail.gmail.com>
	<82DAA0BC-52E8-4279-81DF-14373755A42F@richrelevance.com>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha1;
	protocol="application/pgp-signature"; boundary="UExESr5xZTMxdOWv"
Content-Disposition: inline
In-Reply-To: <82DAA0BC-52E8-4279-81DF-14373755A42F@richrelevance.com>
User-Agent: Mutt/1.5.18 (2008-05-17)


--UExESr5xZTMxdOWv
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

On Thu, Jul 22, 2010 at 02:44:04PM -0700, Scott Carey wrote:
> On Jul 22, 2010, at 11:36 AM, Robert Haas wrote:
> > On Mon, Jul 12, 2010 at 6:58 AM, Craig Ringer
> > <craig@postnewspapers.com.au> wrote:
> >> So rather than asking "should core have a connection pool" perhaps
> >> what's needed is to ask "what can an in-core pool do that an external
> >> pool cannot do?"
> >=20
> > Avoid sending every connection through an extra hop.
> >=20
>=20
> Dynamically adjust settings based on resource usage of the DB.
>=20

Relatively minor, but it would be convenient to avoid having to query
$external_pooler to determine the client_addr of an incoming connection.

--
Joshua Tolley / eggyknap
End Point Corporation
http://www.endpoint.com

--UExESr5xZTMxdOWv
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: Digital signature
Content-Disposition: inline

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.9 (GNU/Linux)

iEYEARECAAYFAkxJu3cACgkQRiRfCGf1UMPNzQCfetoZ7SwRULD3xJ2iERQdRqYm
NnwAn3LfYtK/YsHOHNzDcqR519hnTDKo
=Xx/n
-----END PGP SIGNATURE-----

--UExESr5xZTMxdOWv--