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)