MIME-Version: 1.0
From: Siraj G <tosiraj.g@gmail.com>
Date: Tue, 5 Aug 2025 10:18:15 +0530
Message-ID: 
 <CAC5iy61X3Yr-KUfegB61FKE5MP-sbe=Fectsyk8EpFZ4b1t=aA@mail.gmail.com>
Subject: DB load balancer
To: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000519ac9063b96ef87"
Archived-At: 
 <https://www.postgresql.org/message-id/CAC5iy61X3Yr-KUfegB61FKE5MP-sbe%3DFectsyk8EpFZ4b1t%3DaA%40mail.gmail.com>
Precedence: bulk

--000000000000519ac9063b96ef87
Content-Type: text/plain; charset="UTF-8"

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

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

<div dir=3D"ltr">Hello Experts!<div><br></div><div>We have a multi tenant m=
odel DB with a Primary and a Secondary. There are 3x or 4x connections flow=
ing to Secondary as the application is read intensive. Accordingly we have =
allocated more number of resources to the VM hosting the secondary/replica =
DB.=C2=A0</div><div><br></div><div>Spec:-=C2=A0</div><div>Primary: 48 CPUs,=
 48GB memory</div><div>Secondary: 80 CPUs, 128GB memory</div><div>PG versio=
n: 12.22 (we have already started the upgrade process)</div><div>OS: Ubuntu=
</div><div><br></div><div>The problem very frequently we are experiencing i=
s that the CPU load on the SECONDARY is going very very high causing the ap=
p slowness. Also, frequently the postgres is crashing due to OOM.</div><div=
><br></div><div>I was thinking of these (please give feedback):</div><div>1=
. Have a DB level balancer for the load balancing in the DB level, meaning =
primary will also receive the READ traffic</div><div>2. Add a second REPLIC=
A and configure load balancer for the connection load balancing</div><div><=
br></div><div>What do we do for load balancing at the DB level, in postgres=
?</div><div><br></div><div>If there are any suggestions, please=C2=A0let me=
 know.</div><div><br></div><div>Regards</div><div>Siraj</div></div>

--000000000000519ac9063b96ef87--