MIME-Version: 1.0
From: KK CHN <kkchn.in@gmail.com>
Date: Fri, 23 Jan 2026 23:44:45 +0530
Message-ID: <CAKgGyB9z_dN_5vOGS34CNMrT74F4OQWBToCHoSjsWShVDOGZyQ@mail.gmail.com>
Subject: Resource Usage same In spite of fronting my DB server with Pgbouncer ?
To: pgsql-general <pgsql-general@postgresql.org>
Content-Type: multipart/alternative; boundary="0000000000006c73940649120c8f"
Archived-At: <https://www.postgresql.org/message-id/CAKgGyB9z_dN_5vOGS34CNMrT74F4OQWBToCHoSjsWShVDOGZyQ%40mail.gmail.com>
Precedence: bulk

--0000000000006c73940649120c8f
Content-Type: text/plain; charset="UTF-8"

List,
I am fronting my postgres 16 server with  pgbouncer1.23.1

What surprises me,  even though I am deploying  pgbouncer as a separate VM
in front of DB server VM,  the top command shows the almost same resource
usage statistics in the case of load averages, Memory usage etc on the DB
Server,  whether I am infronting DB server with pgbouncer or not.

Please find the top  output from the db server pasted here.

https://glot.io/snippets/hf4ilogbz0

My Pgbouncer server  top output  shows littler resource usages in terms of
CPU, MEM usage
on the top out put of  pgbouncer VM ( load averagaes  less than 3  always,
and Ram usage is very low,  swap usage almost nil..


Why eventhough I have deployed  pgbouncer  for this setup why DB server
still shows large resource usage as in the pasted out put.

How can I improve the resource usages on DB server ?  what is the root
cause DB server's still high resource usage ?

Any hints are most welcome .

My  pgbouncer.ini  config params pasted here for  any valuable suggestions
for fine tuning.


[root@pgbouncer ~]# grep ^[^\;\;] /usr/local/etc/pgbouncer.ini
[databases]

recoil = host=dbmain.erss.in port=5444 dbname=recoil
[users]
[pgbouncer]
logfile = /var/log/pgbouncer/pgbouncer.log
pidfile = /var/run/pgbouncer/pgbouncer.pid
listen_addr = *
listen_port = 5444
auth_type = md5
auth_file = /usr/local/etc/pgbouncer.users
admin_users = myuser
stats_users = myuser,
pool_mode = transaction
max_prepared_statements = 100
server_reset_query = DISCARD ALL
server_reset_query_always = 1
ignore_startup_parameters = extra_float_digits, options, statement_timeout,
idle_in_transaction_session_timeout

max_client_conn = 5000
default_pool_size = 50
min_pool_size =  30
reserve_pool_size = 10
reserve_pool_timeout = 5
max_db_connections = 900
max_user_connections = 800
server_lifetime = 3600
server_idle_timeout = 60000
[root@pgbouncer ~]#


Regards,
Krishane

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

<div dir=3D"ltr"><br><div><br></div><div><br></div><div>List,=C2=A0=C2=A0</=
div><div>I am fronting my postgres 16 server with=C2=A0 pgbouncer1.23.1=C2=
=A0=C2=A0</div><div><br></div><div>What surprises me,=C2=A0 even though I a=
m deploying=C2=A0 pgbouncer as a separate VM in front of DB server VM,=C2=
=A0 the top command shows the almost same resource usage statistics in the =
case of load averages, Memory usage etc on the DB Server,=C2=A0 whether I a=
m infronting DB server with pgbouncer or not.=C2=A0</div><div><br></div><di=
v>Please find the top=C2=A0 output from the db server pasted here.=C2=A0</d=
iv><div><br></div><div><a href=3D"https://glot.io/snippets/hf4ilogbz0">http=
s://glot.io/snippets/hf4ilogbz0</a></div><div><br></div><div>My Pgbouncer s=
erver=C2=A0 top output=C2=A0 shows littler resource usages in terms of CPU,=
 MEM usage=C2=A0</div><div>on the top out put of=C2=A0 pgbouncer VM ( load =
averagaes=C2=A0 less than 3=C2=A0 always,=C2=A0 and Ram usage is very low,=
=C2=A0 swap usage almost nil..=C2=A0</div><div><br></div><div><br></div><di=
v>Why eventhough=C2=A0I have deployed=C2=A0 pgbouncer=C2=A0 for this setup =
why DB server still shows large resource usage as in the pasted out put.=C2=
=A0</div><div><br></div><div>How can I improve the resource usages on DB se=
rver ?=C2=A0 what is the root cause DB server&#39;s still high resource usa=
ge ?</div><div><br></div><div>Any hints are most welcome .</div><div><br></=
div><div>My=C2=A0 pgbouncer.ini=C2=A0 config params pasted here for=C2=A0 a=
ny valuable suggestions for fine tuning.</div><div><br></div><div><br></div=
><div>[root@pgbouncer ~]# grep ^[^\;\;] /usr/local/etc/pgbouncer.ini<br>[da=
tabases]<br><br>recoil =3D host=3D<a href=3D"http://dbmain.erss.in">dbmain.=
erss.in</a> port=3D5444 dbname=3Drecoil<br>[users]<br>[pgbouncer]<br>logfil=
e =3D /var/log/pgbouncer/pgbouncer.log<br>pidfile =3D /var/run/pgbouncer/pg=
bouncer.pid<br>listen_addr =3D *<br>listen_port =3D 5444<br>auth_type =3D m=
d5<br>auth_file =3D /usr/local/etc/pgbouncer.users<br>admin_users =3D myuse=
r<br>stats_users =3D myuser,<br>pool_mode =3D transaction<br>max_prepared_s=
tatements =3D 100<br>server_reset_query =3D DISCARD ALL<br>server_reset_que=
ry_always =3D 1<br>ignore_startup_parameters =3D extra_float_digits, option=
s, statement_timeout, idle_in_transaction_session_timeout<br><br>max_client=
_conn =3D 5000<br>default_pool_size =3D 50<br>min_pool_size =3D =C2=A030<br=
>reserve_pool_size =3D 10<br>reserve_pool_timeout =3D 5<br>max_db_connectio=
ns =3D 900<br>max_user_connections =3D 800<br>server_lifetime =3D 3600<br>s=
erver_idle_timeout =3D 60000<br>[root@pgbouncer ~]#</div><div><br></div><di=
v><br></div><div>Regards,</div><div>Krishane</div></div>

--0000000000006c73940649120c8f--