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

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Achilleas Mantzios <a(dot)mantzios(at)cloud(dot)gatewaynet(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:07:12
Message-ID: CAKFQuwa2pM4FTXpomL_tkeFmHkB+1xk2OO9j=2AtQ5xcy7fMow@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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.

David J.

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Achilleas Mantzios 2024-11-18 20:54:29 Re: Mysterious connections to PostgreSQL (no statement) coming from pgbouncer (mode = transaction)
Previous Message Achilleas Mantzios 2024-11-18 20:03:03 Mysterious connections to PostgreSQL (no statement) coming from pgbouncer (mode = transaction)