How to reduce the load?

Question

PostgreSQL

Good evening!

There is a project and when the site goes online under 200, the server is fully loaded at 100% (8 cores, 16 oz)
It is loaded mainly by hasura and postgres

What can you advise to reduce the load on the server or should everything be distributed over several servers?

Answer 1

Well, for starters, it would be nice to twist the postgres config + see what the application is constantly doing there, which eats up all the resources. 200 online is never a highlod

Answer 2

In this formulation of the question - nothing. It is necessary to look at what and how accesses the database. There can be many problems - from poor query optimization and crooked indexes, to constantly getting data that can be cached.