Re: PgBouncer doubts

On 06/11/2014 07:26 AM, Christian Jauvin wrote:
>> To make things clearer, what log are we looking at, the PgBouncer or
>> Postgres?
>
> This is the PgBouncer log.
>
>> The log is showing that the client is requesting that the connection be
>> closed. So my guess is that teardown_request is being run for a reason you
>> have not accounted for.
>
> Actually, teardown_request should be executed for every single
> interaction with the app (after every Ajax call for instance), so one
> thing I tried (under the assumption that maybe the psycopg2 connection
> should not be explicitly closed in such a PgBouncer-enabled setup) is
> to simply comment it all out, but it didn't change the PgBouncer
> behavior at all.

Web apps tend to spawn a lot of connections so this is not surprising.

>
> Also, according to this answer to the same question on dba.SE, it
> seems that this log is
> the expected behavior:
>
> http://dba.stackexchange.com/a/67982/40738
>

Yea, it looks like it is cycling through connections.

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com