Postgres Pro
Downloads
Home   >   mailing lists

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

From David G. Johnston
Subject Re: Mysterious connections to PostgreSQL (no statement) coming from pgbouncer (mode = transaction)
Date
Msg-id CAKFQuwa2pM4FTXpomL_tkeFmHkB+1xk2OO9j=2AtQ5xcy7fMow@mail.gmail.com
Whole thread Raw
In response to Mysterious connections to PostgreSQL (no statement) coming from pgbouncer (mode = transaction)  (Achilleas Mantzios <a.mantzios@cloud.gatewaynet.com>)
Responses Re: Mysterious connections to PostgreSQL (no statement) coming from pgbouncer (mode = transaction)
List pgsql-admin
Tree view
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.

David J.

pgsql-admin by date:

Previous
From: Achilleas Mantzios
Date:
Subject: Mysterious connections to PostgreSQL (no statement) coming from pgbouncer (mode = transaction)
Next
From: Achilleas Mantzios
Date:
Subject: Re: Mysterious connections to PostgreSQL (no statement) coming from pgbouncer (mode = transaction)