Re: Explanantion on pgbouncer please

> -----Original Message-----
> From: pgsql-general-owner(at)postgresql(dot)org [mailto:pgsql-general-
> owner(at)postgresql(dot)org] On Behalf Of si24
> Sent: Thursday, October 31, 2013 10:25 AM
> To: pgsql-general(at)postgresql(dot)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 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