Answer the question
In order to leave comments, you need to log in
PostgreSQL loads the processor up to 100%, who faced it?
There was such a problem, the request select this_.id as y0_ from vacancies this_ where this_.company_id=$1 limit $2 loads the processor by 100%, it is executed by hand with a bang and very fast, the server configuration is sufficient, for a base of 6GB - 16GB of RAM, 6 cores . Changing and tuning the config does not help. "Limit" costs 1000.
Already hands down, and everything was fine, worked well, and then bang and that's it, loading 100%. The service is written in Java.
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question