pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Greg Smith <greg@2ndquadrant.com>
To: Joshua Tolley <eggyknap@gmail.com>
Cc: Scott Carey <scott@richrelevance.com>
Cc: Robert Haas <robertmhaas@gmail.com>
Cc: Craig Ringer <craig@postnewspapers.com.au>
Cc: Matthew Wakeling <matthew@flymine.org>
Cc: pgsql-performance@postgresql.org <pgsql-performance@postgresql.org>
Subject: Re: Pooling in Core WAS: Need help in performance tuning.
Date: Sat, 24 Jul 2010 01:23:08 -0400
Message-ID: <4C4A78BC.2020101@2ndquadrant.com> (raw)
In-Reply-To: <4c49bb81.17bb720a.42c2.1de8@mx.google.com>
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>

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




view thread (59+ messages)  latest in thread

Message-ID: <4C4A78BC.2020101@2ndquadrant.com>
Permalink:  ../4C4A78BC.2020101@2ndquadrant.com/
Also on:    postgresql.org/message-id/4C4A78BC.2020101@2ndquadrant.com

 · 

reply
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: greg@2ndquadrant.com, eggyknap@gmail.com, scott@richrelevance.com, robertmhaas@gmail.com, craig@postnewspapers.com.au, matthew@flymine.org
  Subject: Re: Pooling in Core WAS: Need help in performance tuning.
  In-Reply-To: <4C4A78BC.2020101@2ndquadrant.com>

* 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