Re: Explanantion on pgbouncer please

> -----Original Message-----
> From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-
> owner@postgresql.org] On Behalf Of si24
> Sent: Thursday, October 31, 2013 10:25 AM
> To: pgsql-general@postgresql.org
> Subject: [GENERAL] 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
connectionsto 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
commandssuch as "show pools", "show clients", etc... 

Regards,
Igor Neyman