public inbox for [email protected]
help / color / mirror / Atom feedFrom: Siraj G <[email protected]>
To: Deepak Goel <[email protected]>
Cc: Pgsql-admin <[email protected]>
Subject: Re: DB load balancer
Date: Tue, 5 Aug 2025 11:41:53 +0530
Message-ID: <CAC5iy61myDZv=PWQXyywNv+jLYXTGbJ1+rhZeWii3Y0H8vG5fA@mail.gmail.com> (raw)
In-Reply-To: <CA+b7NVXqrV8b6O=6OkSNLS97BuD2L1orss_D8hPL2ta_PiMpoQ@mail.gmail.com>
References: <CAC5iy61X3Yr-KUfegB61FKE5MP-sbe=Fectsyk8EpFZ4b1t=aA@mail.gmail.com>
<CA+b7NVXqrV8b6O=6OkSNLS97BuD2L1orss_D8hPL2ta_PiMpoQ@mail.gmail.com>
Hello Deepak
CPU utilization is high, below is just a 1 day utilization graph. We have
been having these more often between 3:30 and 5:30 in the afternoon. This
is a daily pattern and during this the application response goes very slow.
[image: image.png]
Regards
Siraj
On Tue, Aug 5, 2025 at 10:51 AM Deepak Goel <[email protected]> wrote:
> Please share what you mean by slow (CPU usage of secondary over time,
> response times of the transactions over time).
>
>
> Deepak
> "The greatness of a nation can be judged by the way its animals are
> treated - Mahatma Gandhi"
>
> +91 73500 12833
> [email protected]
>
> LinkedIn: www.linkedin.com/in/deicool
>
> "Plant a Tree, Go Green"
>
> Make In India : http://www.makeinindia.com/home
>
>
> On Tue, Aug 5, 2025 at 10:18 AM Siraj G <[email protected]> wrote:
>
>> Hello Experts!
>>
>> We have a multi tenant model DB with a Primary and a Secondary. There are
>> 3x or 4x connections flowing to Secondary as the application is read
>> intensive. Accordingly we have allocated more number of resources to the VM
>> hosting the secondary/replica DB.
>>
>> Spec:-
>> Primary: 48 CPUs, 48GB memory
>> Secondary: 80 CPUs, 128GB memory
>> PG version: 12.22 (we have already started the upgrade process)
>> OS: Ubuntu
>>
>> The problem very frequently we are experiencing is that the CPU load on
>> the SECONDARY is going very very high causing the app slowness. Also,
>> frequently the postgres is crashing due to OOM.
>>
>> I was thinking of these (please give feedback):
>> 1. Have a DB level balancer for the load balancing in the DB level,
>> meaning primary will also receive the READ traffic
>> 2. Add a second REPLICA and configure load balancer for the connection
>> load balancing
>>
>> What do we do for load balancing at the DB level, in postgres?
>>
>> If there are any suggestions, please let me know.
>>
>> Regards
>> Siraj
>>
>
Attachments:
[image/png] image.png (68.4K, 3-image.png)
download | view image
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected]
Subject: Re: DB load balancer
In-Reply-To: <CAC5iy61myDZv=PWQXyywNv+jLYXTGbJ1+rhZeWii3Y0H8vG5fA@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox