Capacity Planning for the primary database (closed)
It has been a long time since our last capacity planning, and we would like to verify:
- How much more load we could add on the primary database without degradation in the performance.
- We are reaching 60k connections per second. How much could we raise safely?
- Should we increase disk or memory to optimize performance? Any suggestions in shared buffers setup?
- Estimate how much % of the load is related to the table merge_requests.
- Add more topics that you think could be the next bottleneck to scale the availability of our primary database.
- measure the hot set of data that we use at the moment in memory. How much are we hitting disk. (
pg_buffercache
and the LRU count)
Edited by Alberto Ramos