A
A
a1exkos2016-03-18 05:01:02
PostgreSQL
a1exkos, 2016-03-18 05:01:02

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

1 answer(s)
L
lega, 2016-03-18
@a1exkos

Is there an index on the company_id field?

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question