Re: Explanantion on pgbouncer please

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