Re: Resource Usage same In spite of fronting my DB server with Pgbouncer ?

On 1/23/26 10:14 AM, KK CHN wrote:
>
>
>
> 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 <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.

That would seem logical to me as pgBouncer is just passing the
connections to the Postgres server, the server is doing the heavy
lifting of dealing with statements in the connections.

From the top output it looks like you are working with some form of a
EDB product. You need to specify what that product is and it's version.
This list is for the community version of Postgres and people will
assume that is what you are talking about. There are folks that maybe
able to help with EDB versions, but they need to know what it is.

> Regards,
> Krishane