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 | Configured memory percentage. 0 indicates that the memory of the resource pool is not controlled. |
cpu_affinity | bigint | Reserved column without an actual meaning |
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 | Estimated memory upper limit for a query. |
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 |
nodegroup | name | Name of the logical cluster associated with the resource pool. The value is installation for a non-logical cluster. |
is_foreign | boolean | 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. |
short_acc | boolean | Whether to enable short query acceleration for a resource pool. This function is enabled by default.
|
except_rule | text | Exception rule associated with a resource pool. There can be multiple associated rules, which are separated by commas (,). |
weight | integer | Resource scheduling weight. Currently, this parameter is used only for network scheduling. |