Home / server / Questions / 1034846
In Process
user2085899
Asked: 2020-09-22 23:03:40 +0800 CST

Uneven processor usage on a Multi core Postgre SQL server

  • 772

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?

linux postgresql cpu-usage

1 Answers

  1. 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

    • 0