Re: Mysterious connections to PostgreSQL (no statement) coming from pgbouncer (mode = transaction)

From: Achilleas Mantzios <a(dot)mantzios(at)cloud(dot)gatewaynet(dot)com>
To: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
Cc: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: Mysterious connections to PostgreSQL (no statement) coming from pgbouncer (mode = transaction)
Date: 2024-11-18 20:54:29
Message-ID: ee523c17-463d-4034-abcb-091924272720@cloud.gatewaynet.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-admin


Στις 18/11/24 22:07, ο/η David G. Johnston έγραψε:
> On Mon, Nov 18, 2024 at 1:03 PM Achilleas Mantzios
> <a(dot)mantzios(at)cloud(dot)gatewaynet(dot)com> wrote:
>
> We have been running pgbouncer (since 1.8) for quite some years,
> and today I realized I have connections to the DB from pgbouncer
> that don't do anything, do not execute any statement.
>
>
> Seems reasonable that a pooler would open connections to PostgreSQL to
> prime the pool even before any demand is seen.  That way demand is
> immediately given a functioning connection.

Hello David,

I forgot to mention that in pgbouncer : min_pool_size=0 . So not reasonable.

>
> David J.
>

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message David G. Johnston 2024-11-19 15:31:28 Re: Broken behavior after minor update CVE-2024-10978
Previous Message David G. Johnston 2024-11-18 20:07:12 Re: Mysterious connections to PostgreSQL (no statement) coming from pgbouncer (mode = transaction)