0

We have a dedicated server running Postgres 12 database with this configuration:

Model: HPE ProLiant DL580 Gen9
CPUs: 4*Intel(R) Xeon(R) CPU E7-4850 v3 @ 2.20GHz
Ram: 128 GB
Ubuntu 18.04.4 LTS
Postgre SQL 12

The problem is that the CPU usage never reach 50%. When I checked ZABBIX logs found out when CPU usage becomes more than 40% COU Softirq time increases as you see:

enter image description here

When I checked PRTG Logs, saw something weird; The utilization of some CPUs are up to 80% but most of them are less than 20.

enter image description here

What's happenning here? How can I use all of my CPUs?

Improve this question

1 Answer 1

Reset to default
0

You're describing one or two intensive queries. From experience Postgres will use multiple core's but each query is bound to a single core / thread (related I/O can be on other cores

Improve this answer
1
  • Our queries are so fast. most of them are executing in less than 1s. And thre is not any other important services running on the server Commented Sep 24, 2020 at 5:00

You must log in to answer this question.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.