PG_RESOURCE_POOL
PG_RESOURCE_POOL records the information about database resource pool.
Name |
Type |
Description |
---|---|---|
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 number of concurrent simple jobs allowed by the resource pool. -1 and 0 indicate that there are no limitations. |
memory_limit |
name |
Maximum memory of resource pool |
parentid |
oid |
OID of the parent resource pool |
io_limits |
integer |
Reserved column without an actual meaning |
io_priority |
text |
Reserved column without an actual meaning |
is_foreign |
boolean |
Indicates whether the resource pool can be used for users outside the logical cluster. If it is set to true, the resource pool controls the resources of common users who do not belong to the current resource pool. |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.