MIME-Version: 1.0
References: <c72370a9-a8d0-411e-ba0d-04079816fb61@cloud.gatewaynet.com>
In-Reply-To: <c72370a9-a8d0-411e-ba0d-04079816fb61@cloud.gatewaynet.com>
From: "David G. Johnston" <david.g.johnston@gmail.com>
Date: Mon, 18 Nov 2024 13:07:12 -0700
Message-ID: 
 <CAKFQuwa2pM4FTXpomL_tkeFmHkB+1xk2OO9j=2AtQ5xcy7fMow@mail.gmail.com>
Subject: Re: Mysterious connections to PostgreSQL (no statement) coming from
 pgbouncer (mode = transaction)
To: Achilleas Mantzios <a.mantzios@cloud.gatewaynet.com>
Cc: pgsql-admin@lists.postgresql.org
Content-Type: multipart/alternative; boundary="0000000000007b370c06273578ef"
Archived-At: 
 <https://www.postgresql.org/message-id/CAKFQuwa2pM4FTXpomL_tkeFmHkB%2B1xk2OO9j%3D2AtQ5xcy7fMow%40mail.gmail.com>
Precedence: bulk

--0000000000007b370c06273578ef
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Mon, Nov 18, 2024 at 1:03=E2=80=AFPM Achilleas Mantzios <
a.mantzios@cloud.gatewaynet.com> wrote:

> We have been running pgbouncer (since 1.8) for quite some years, and toda=
y
> 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.

--0000000000007b370c06273578ef
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr"><div class=3D"gmail_default" style=3D"fon=
t-family:arial,helvetica,sans-serif"><span style=3D"font-family:Arial,Helve=
tica,sans-serif">On Mon, Nov 18, 2024 at 1:03=E2=80=AFPM Achilleas Mantzios=
 &lt;<a href=3D"mailto:a.mantzios@cloud.gatewaynet.com">a.mantzios@cloud.ga=
tewaynet.com</a>&gt; wrote:</span></div></div><div class=3D"gmail_quote"><b=
lockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-le=
ft:1px solid rgb(204,204,204);padding-left:1ex"><u></u>

 =20

   =20
 =20
  <div>
    <p>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&#39;t do anything, do not execute any statement.</p></div></=
blockquote><div><br></div><div class=3D"gmail_default" style=3D"font-family=
:arial,helvetica,sans-serif">Seems reasonable that a pooler would open conn=
ections to PostgreSQL to prime the pool even before any demand is seen.=C2=
=A0 That way demand is immediately given a functioning connection.</div><di=
v class=3D"gmail_default" style=3D"font-family:arial,helvetica,sans-serif">=
<br></div><div class=3D"gmail_default" style=3D"font-family:arial,helvetica=
,sans-serif">David J.</div><div class=3D"gmail_default" style=3D"font-famil=
y:arial,helvetica,sans-serif"><br></div></div></div>

--0000000000007b370c06273578ef--