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

[Achilleas Mantzios <a.mantzios@xxxxxxxxxxxxxxxxxxxx>]

Στις 18/11/24 22:07, ο/η David G. Johnston έγραψε:

On Mon, Nov 18, 2024 at 1:03 PM Achilleas Mantzios <a.mantzios@xxxxxxxxxxxxxxxxxxxx> 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.