Postgres Pro
Downloads
Home   >   mailing lists

Re: Mysterious connections to PostgreSQL (no statement) coming from pgbouncer (mode = transaction) - Mailing list pgsql-admin

From Achilleas Mantzios
Subject Re: Mysterious connections to PostgreSQL (no statement) coming from pgbouncer (mode = transaction)
Date
Msg-id ee523c17-463d-4034-abcb-091924272720@cloud.gatewaynet.com
Whole thread Raw
In response to Re: Mysterious connections to PostgreSQL (no statement) coming from pgbouncer (mode = transaction)  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-admin
Tree view


Στις 18/11/24 22:07, ο/η David G. Johnston έγραψε:
On Mon, Nov 18, 2024 at 1:03 PM Achilleas Mantzios <a.mantzios@cloud.gatewaynet.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.

pgsql-admin by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: Mysterious connections to PostgreSQL (no statement) coming from pgbouncer (mode = transaction)
Next
From: "David G. Johnston"
Date:
Subject: Re: Broken behavior after minor update CVE-2024-10978