horizontal-scaling – Tarik Billa

Can relational database scale horizontally

April 4, 2023 by Tarik

It is possible but takes lots of maintenance efforts, Explanation – Vertical Scaling of data (synonymous to Normalisation in SQL databases) is referred as splitting data column wise into multiple tables in order to reduce space redundancy. Example of user table – Horizontal Scaling of data (synonymous to sharding) is referred as splitting row wise … Read more

Scaling Postgres horizontally

March 30, 2023 by Tarik

If it is about read-heavy workload then you should just add replicas. Add as many replicas as you need to handle the whole workload. You can balance all the queries across the replicas in the round robin fashion. If it is about write-heavy workload, then you should partition your database across many servers. You can … Read more