Message-ID: <4C4A78BC.2020101@2ndquadrant.com>
Date: Sat, 24 Jul 2010 01:23:08 -0400
From: Greg Smith <greg@2ndquadrant.com>
User-Agent: Thunderbird 2.0.0.24 (X11/20100317)
MIME-Version: 1.0
To: Joshua Tolley <eggyknap@gmail.com>
CC: Scott Carey <scott@richrelevance.com>,
	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>
	<4c49bb81.17bb720a.42c2.1de8@mx.google.com>
In-Reply-To: <4c49bb81.17bb720a.42c2.1de8@mx.google.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

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

You suggest this as a minor concern, but I consider it to be one of the 
most compelling arguments in favor of in-core pooling.  A constant pain 
with external poolers is the need to then combine two sources of data in 
order to track connections fully, which is something that everyone runs 
into eventually and finds annoying.  It's one of the few things that 
doesn't go away no matter how much fiddling you do with pgBouncer, it's 
always getting in the way a bit.  And it seems to seriously bother 
systems administrators and developers, not just the DBAs.

-- 
Greg Smith  2ndQuadrant US  Baltimore, MD
PostgreSQL Training, Services and Support
greg@2ndQuadrant.com   www.2ndQuadrant.us