From: | hubert depesz lubaczewski <depesz(at)depesz(dot)com> |
---|---|
To: | si24 <smrcoutts24(at)gmail(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Explanantion on pgbouncer please |
Date: | 2013-10-31 17:42:20 |
Message-ID: | 20131031174220.GA32390@depesz.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On czw, paź 31, 2013 at 07:25:21 -0700, si24 wrote:
> Can some one please give me a bit more of a better explanation on how exactly
> the pgbouncer works as I am now lost.
>
> I'm not sure if it is pooling the connections cause surely if its not being
> used the connections should go down not up i.e i run the webpage which has
> my map running which is an open layers map reading geoserver all my data on
> geoserver is from a database in postgres. When you start the web page it
> goes to 46 connections and after moving around for a while and selecting the
> different overlays that I have on the map it goes up to 75 connections after
> not touching it for a while nothing happens the connections don't go up or
> down, but when I move the map around and zoom then the connections increase
> again to 84 connections.
You probably are using "session pooling" mode in pgbouncer, and
persistent connections in app.
This is generally not so good idea.
Reasons, explanation, and suggestions:
http://www.depesz.com/2012/12/02/what-is-the-point-of-bouncing/
depesz
From | Date | Subject | |
---|---|---|---|
Next Message | Yostin Vargas | 2013-10-31 18:12:13 | Re: Table with Field Serial - Problem |
Previous Message | David Johnston | 2013-10-31 17:29:38 | Re: Explanantion on pgbouncer please |