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 IOPS. It is counted by 10,000 per second for row store. |
io_priority |
name |
I/O priority set for jobs that consume many I/O resources. It takes effect when the I/O usage reaches 90%. |
nodegroup |
name |
Name of the logical database to which the resource pool belongs. |
is_foreign |
Boolean |
Specifies 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