> -----Original Message----- > From: pgsql-general-owner@xxxxxxxxxxxxxx [mailto:pgsql-general- > owner@xxxxxxxxxxxxxx] On Behalf Of si24 > Sent: Thursday, October 31, 2013 10:25 AM > To: pgsql-general@xxxxxxxxxxxxxx > Subject: Explanantion on pgbouncer please > > 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. > > Please help I'm stuck > First, when you are describing your situation, please be specific what connections you are talking about: client connections to PgBouncer or pool connections from PgBouncer to Postgres server. Second, you could learn a lot about status of your connections, when you connect as administrator to PgBouncer and use commands such as "show pools", "show clients", etc... Regards, Igor Neyman -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
