PG_RESOURCE_POOL
PG_RESOURCE_POOL provides information about database resource pools.
Table 1 PG_RESOURCE_POOL columns
Name | Type | Description |
---|
oid | oid | Row identifier (hidden attribute, which must be specified) |
respool_name | name | Name of the resource pool |
mem_percent | integer | Percentage of the memory configuration |
cpu_affinity | bigint | Value of cores bound to the CPU |
control_group | name | Name of the Cgroup where the resource pool is located |
active_statements | integer | Maximum number of concurrent statements in the resource pool |
max_dop | integer | Maximum scanning concurrency during data redistribution. This column is used for scaling. |
memory_limit | name | Maximum memory of the resource pool |
parentid | oid | OID of the parent resource pool |
io_limits | integer | Upper limit of I/O operations per second. It is counted by ones for column storage and by 10 thousands for row storage. |
io_priority | name | I/O priority set for jobs that consume many I/O resources. It takes effect when I/O usage reaches 90%. |
nodegroup | name | Name of the logical openGauss to which the resource pool belongs |
is_foreign | boolean | Whether the resource pool can be used for users outside the logical openGauss. If it is set to true, the resource pool controls the resources of common users who do not belong to the current resource pool. |
max_worker | integer | Concurrency in a table during data redistribution. This column is used only for scaling. |
Note: max_dop and max_worker are used for scaling and are not applicable to the centralized deploymentopenGauss.
openGauss 2025-04-30 22:43:40