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
signature.asc
Description: Digital signature
