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"
"Plant a Tree, Go Green"
Make In India : http://www.makeinindia.com/home
On Tue, Aug 5, 2025 at 10:18 AM Siraj G <tosiraj.g@xxxxxxxxx> 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 memorySecondary: 80 CPUs, 128GB memoryPG version: 12.22 (we have already started the upgrade process)OS: UbuntuThe 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 traffic2. Add a second REPLICA and configure load balancer for the connection load balancingWhat do we do for load balancing at the DB level, in postgres?If there are any suggestions, please let me know.RegardsSiraj
