Re: Explanantion on pgbouncer please

From: si24 <smrcoutts24(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Explanantion on pgbouncer please
Date: 2013-10-31 14:46:44
Message-ID: 1383230804695-5776522.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I'm not a 100% sure but when i type : select count (*) from pg_stat_activity;
in postgres it give me the a number be 3 or 75 or higher depending on what
is runnung at the time if its the webpage with the map or just postgres
itself.

I had thought that the client connections to PgBouncer and pool connections
from PgBouncer to Postgres server was pretty much the same the same thing.
that could also be a problem maybe i'm not understanding the full length of
the connection term to well. I just know that I have been struggleing with
this for a few days now and am still have not come to much closer to
understanding it (i think). The pdf part that I had read that showed you how
to set it up and shows you the command section on the show pools and all. I
had did that. but will check it out again then.

--
View this message in context: http://postgresql.1045698.n5.nabble.com/Explanantion-on-pgbouncer-please-tp5776515p5776522.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2013-10-31 14:46:48 Re: Table with Field Serial - Problem
Previous Message Adam Brusselback 2013-10-31 14:38:57 Re: Explanantion on pgbouncer please