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

From Hannu Krosing
Subject Re: Pooling in Core WAS: Need help in performance tuning.
Date
Msg-id 1279826144.14271.5.camel@hvost
Whole thread Raw
In response to Re: Pooling in Core WAS: Need help in performance tuning.  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: Pooling in Core WAS: Need help in performance tuning.
List pgsql-performance
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


there will still be "an extra hop",only it will be local, between pooler
and backend process.

similar to what currently happens with pgbouncer when you deploy it on
same server and use unix sockets

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



pgsql-performance by date:

Previous
From: Andres Freund
Date:
Subject: Re: Pooling in Core WAS: Need help in performance tuning.
Next
From: Hannu Krosing
Date:
Subject: Re: Pooling in Core WAS: Need help in performance tuning.