Help Center > > Developer Guide> System Catalogs and System Views> System Catalogs> PG_RESOURCE_POOL

PG_RESOURCE_POOL

Updated at: Jul 15, 2020 GMT+08:00

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

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 concurrency. This is a reserved parameter.

memory_limit

name

Maximum memory of resource pool

parentid

oid

OID of the parent resource pool

io_limits

integer

Upper limit of IOPS. It is counted by ones for column storage and by 10 thousands for row storage.

io_priority

text

I/O priority set for jobs that consume many I/O resources. It takes effect when the I/O usage reaches 90%.

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 that do not belong to the current resource pool.

Did you find this page helpful?

Submit successfully!

Thank you for your feedback. Your feedback helps make our documentation better.

Failed to submit the feedback. Please try again later.

Which of the following issues have you encountered?







Please complete at least one feedback item.

Content most length 200 character

Content is empty.

OK Cancel