Top
Enterprise Postgres 17 Operation Guide

12.1 CPU Load Calculation

There may be a case when the user tries to execute a parallel query but there is not enough CPU available.

Adding dynamic workers at this stage will provide no benefits - instead, it may add overhead due to context switching.

Fujitsu Enterprise Postgres checks the available CPU resources when determining the number of workers for a parallel query.

When checking the available CPU resources, the system checks the CPU usage (whether there are sufficient free system resources) at the time the SQL statement is executed, and a parallel query is only planned if there is enough free CPU usage for two or more cores on the server.

For example, if a server has four cores and the total free space from core 1 to core 4 is 200% or more, a parallel query will be planned, but if it is less than 200%, a parallel query will not be planned.