Updated on 2024-09-02 GMT+08:00

PG_RESOURCE_POOL

PG_RESOURCE_POOL records the information about database resource pool.

Table 1 PG_RESOURCE_POOL columns

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.

  • If short query acceleration is enabled, simple queries are controlled on the fast lane.
  • If short query acceleration is disabled, and simple queries are controlled on the slow lane.

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.