CREATE RESOURCE GROUP

The CREATE RESOURCE GROUP creates a , which sets the share of CPU that a workload receives when CPU is contended.

This feature is in and subject to change. To share feedback and/or issues, contact Support.

To use CREATE RESOURCE GROUP, you must first .

Required privileges

Only members of the can create resource groups.

Synopsis

Parameters

Parameter	Description
`IF NOT EXISTS`	Create the resource group only if a resource group with the same name does not exist. If one does exist, the statement does nothing and does not return an error.
`name`	The name of the resource group. The name must be unique among resource groups.
`with_resource_group_options`	The resource group options, written as `WITH (option = value, ...)`. For the supported options, refer to Options.

Options

Option	Value	Description
`cpu_weight`	Positive integer	Required. The group’s CPU weight. A group’s share of CPU is its weight divided by the sum of the weights of all user-defined resource groups. For details, refer to .
`max_cpu`	`BOOL`	Whether the group stays in the burst tier when it uses more than its share of CPU. If omitted, `max_cpu` is `false`. For details, refer to .

Examples

Create a resource group

The following statement creates a resource group named reporting with a CPU weight of 100:

CREATE RESOURCE GROUP reporting WITH (cpu_weight = 100);

Create a second resource group named oltp with a larger weight. Set max_cpu so that the group stays in the burst tier when it uses more than its share:

CREATE RESOURCE GROUP oltp WITH (cpu_weight = 300, max_cpu = true);

To view the resource groups and their CPU shares, use :

SHOW RESOURCE GROUPS;

  id |   name    | cpu_weight | max_cpu | cpu_share_percent
-----+-----------+------------+---------+--------------------
  17 | oltp      |        300 |    t    |                75
  18 | reporting |        100 |    f    |                25
(2 rows)

Create a resource group only if it does not exist

The following statement does nothing, because a resource group named reporting already exists:

CREATE RESOURCE GROUP IF NOT EXISTS reporting WITH (cpu_weight = 50);

Without IF NOT EXISTS, the statement returns an error:

CREATE RESOURCE GROUP reporting WITH (cpu_weight = 50);

ERROR: resource group "reporting" already exists
SQLSTATE: 42710

Assign sessions to a new resource group

After you create a resource group, assign sessions to it with the resource_group . The following statement assigns all future sessions of the report_user role to the reporting group:

ALTER ROLE report_user SET resource_group = 'reporting';

For all of the ways to assign sessions to a resource group, refer to .

Statements

Syntax

Data Types

Spatial Data

Constraints

CREATE RESOURCE GROUP

Required privileges

Synopsis

Parameters

Options

Examples

Create a resource group

Create a resource group only if it does not exist

Assign sessions to a new resource group

See also

​Required privileges

​Synopsis

​Parameters

​Options

​Examples

​Create a resource group

​Create a resource group only if it does not exist

​Assign sessions to a new resource group

​See also

Required privileges

Synopsis

Parameters

Options

Examples

Create a resource group

Create a resource group only if it does not exist

Assign sessions to a new resource group

See also