Re: Explanantion on pgbouncer please - Mailing list pgsql-general

From John R Pierce
Subject Re: Explanantion on pgbouncer please
Date
Msg-id 527282F9.80906@hogranch.com
Whole thread Raw
In response to Re: Explanantion on pgbouncer please  (Adam Brusselback <adambrusselback@gmail.com>)
List 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 by date:

Previous
From: John R Pierce
Date:
Subject: Re: Connection pooling
Next
From: David Johnston
Date:
Subject: Re: Table with Field Serial - Problem