PG_RESOURCE_POOL
PG_RESOURCE_POOL provides information about database resource pools.
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 database to which the resource pool belongs |
is_foreign |
boolean |
Whether the resource pool can be used for users outside the logical database. 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 deployment.
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot