Re: Resource Usage same In spite of fronting my DB server with Pgbouncer ? - Mailing list pgsql-general

From Adrian Klaver
Subject Re: Resource Usage same In spite of fronting my DB server with Pgbouncer ?
Date
Msg-id 00fe13de-cbfb-4652-8d62-7b7b15dddd39@aklaver.com
Whole thread Raw
In response to Resource Usage same In spite of fronting my DB server with Pgbouncer ?  (KK CHN <kkchn.in@gmail.com>)
Responses Re: Resource Usage same In spite of fronting my DB server with Pgbouncer ?
List pgsql-general

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




pgsql-general by date:

Previous
From: KK CHN
Date:
Subject: Resource Usage same In spite of fronting my DB server with Pgbouncer ?
Next
From: KK CHN
Date:
Subject: Re: Resource Usage same In spite of fronting my DB server with Pgbouncer ?