Re: Pooling in Core WAS: Need help in performance tuning.

Поиск
Список
Период
Сортировка
От Joshua Tolley
Тема Re: Pooling in Core WAS: Need help in performance tuning.
Дата
Msg-id 4c49bb81.17bb720a.42c2.1de8@mx.google.com
обсуждение исходный текст
Ответ на Re: Pooling in Core WAS: Need help in performance tuning.  (Scott Carey <scott@richrelevance.com>)
Ответы Re: Pooling in Core WAS: Need help in performance tuning.  (Greg Smith <greg@2ndquadrant.com>)
Список 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

Вложения

В списке pgsql-performance по дате отправления:

Предыдущее
От: Torsten Zühlsdorff
Дата:
Сообщение: Re: Using more tha one index per table
Следующее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: Pooling in Core WAS: Need help in performance tuning.