Re: Pooling in Core WAS: Need help in performance tuning. - Mailing list pgsql-performance

From Joshua Tolley
Subject Re: Pooling in Core WAS: Need help in performance tuning.
Date
Msg-id 4c49bb81.17bb720a.42c2.1de8@mx.google.com
Whole thread Raw
In response to Re: Pooling in Core WAS: Need help in performance tuning.  (Scott Carey <scott@richrelevance.com>)
Responses Re: Pooling in Core WAS: Need help in performance tuning.
List pgsql-performance
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?"
> >
> > Avoid sending every connection through an extra hop.
> >
>
> Dynamically adjust settings based on resource usage of the DB.
>

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

Attachment

pgsql-performance by date:

Previous
From: Torsten Zühlsdorff
Date:
Subject: Re: Using more tha one index per table
Next
From: "Joshua D. Drake"
Date:
Subject: Re: Pooling in Core WAS: Need help in performance tuning.