Re: Explanantion on pgbouncer please

Поиск
Список
Период
Сортировка
От John R Pierce
Тема Re: Explanantion on pgbouncer please
Дата
Msg-id 527282F9.80906@hogranch.com
обсуждение исходный текст
Ответ на Re: Explanantion on pgbouncer please  (Adam Brusselback <adambrusselback@gmail.com>)
Список pgsql-general
On 10/31/2013 7:38 AM, Adam Brusselback wrote:
>
> If it is from your app to PGBouncer, that sounds strange, and like the
> app is not properly releasing connections as it should.  If it is from
> PGBouncer to PostgreSQL, that sounds normal.  I haven't used
> PGBouncer, but i've used other connection poolers in the past.  They
> would start out with a set number of minimum connections, and scale up
> to the max number specified as needed. The pooler wouldn't release a
> connection to the DB once it has made one, and just kept it available
> in the pool.


except, there's no way a single web page access should be using 70 or 80
connections.  2-3, ok, maybe.


--
john r pierce                                      37N 122W
somewhere on the middle of the left coast



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

Предыдущее
От: John R Pierce
Дата:
Сообщение: Re: Connection pooling
Следующее
От: David Johnston
Дата:
Сообщение: Re: Table with Field Serial - Problem