MIME-Version: 1.0
From: Raj <rajeshkumar.dba09@gmail.com>
Date: Thu, 14 May 2026 17:49:19 +0530
Message-ID: 
 <CAJk5Ata6-cjGenCxEyG2rTARNS6ETovWMX8SZYVvrDBtchSOXA@mail.gmail.com>
Subject: Pgbouncer
To: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000b2e1d90651c61baf"
Archived-At: 
 <https://www.postgresql.org/message-id/CAJk5Ata6-cjGenCxEyG2rTARNS6ETovWMX8SZYVvrDBtchSOXA%40mail.gmail.com>
Precedence: bulk

--000000000000b2e1d90651c61baf
Content-Type: text/plain; charset="UTF-8"

Hi all,

App team using connection pooling and opening 500 sessions which seems to
me stay ,

In this case pgbouncer session pooling or transaction pooling which is
better?

Max_connections in db: 1000

Pool_mode=session
Max connections in pgbouncer: 3000
Default_pool_size=500
Reserve_pool_size=100
Min_pool_size=20

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

<div dir=3D"auto">Hi all,<div dir=3D"auto"><br></div><div dir=3D"auto">App =
team using connection pooling and opening 500 sessions which seems to me st=
ay ,</div><div dir=3D"auto"><br></div><div dir=3D"auto">In this case pgboun=
cer session pooling or transaction pooling which is better?</div><div dir=
=3D"auto"><br></div><div dir=3D"auto">Max_connections in db: 1000</div><div=
 dir=3D"auto"><br></div><div dir=3D"auto">Pool_mode=3Dsession</div><div dir=
=3D"auto">Max connections in pgbouncer: 3000</div><div dir=3D"auto">Default=
_pool_size=3D500</div><div dir=3D"auto">Reserve_pool_size=3D100</div><div d=
ir=3D"auto">Min_pool_size=3D20</div><div dir=3D"auto"><br></div><div dir=3D=
"auto"><br></div><div dir=3D"auto"><br></div></div>

--000000000000b2e1d90651c61baf--