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

From Robert Haas
Subject Re: Pooling in Core WAS: Need help in performance tuning.
Date
Msg-id AANLkTimLr9AoMMB_k9GWuEgoBZg1YWxR5OqKY-1Ugimc@mail.gmail.com
Whole thread Raw
In response to Re: Pooling in Core WAS: Need help in performance tuning.  (Hannu Krosing <hannu@krosing.net>)
Responses Re: Pooling in Core WAS: Need help in performance tuning.
List pgsql-performance
On Thu, Jul 22, 2010 at 3:15 PM, Hannu Krosing <hannu@krosing.net> wrote:
> On Thu, 2010-07-22 at 14:36 -0400, 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.
>
> not really. in-core != magically-in-right-backend-process

Well, how about if we arrange it so it IS in the right backend
process?  I don't believe magic is required.

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise Postgres Company

pgsql-performance by date:

Previous
From: Scott Carey
Date:
Subject: Re: Pooling in Core WAS: Need help in performance tuning.
Next
From: Robert Haas
Date:
Subject: Re: Pooling in Core WAS: Need help in performance tuning.