ALTER RESOURCE GROUP

The ALTER RESOURCE GROUP changes the options of a .

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

To use ALTER RESOURCE GROUP, you must first .

Required privileges

Only members of the can alter resource groups.

Synopsis

Parameters

Parameter	Description
`IF EXISTS`	Alter the resource group only if it exists. If it does not exist, the statement does nothing and does not return an error.
`name`	The name of the resource group to alter.
`with_resource_group_options`	The resource group options to change, written as `WITH (option = value, ...)`. Options that you do not specify keep their current values. For the supported options, refer to Options.

Options

Option	Value	Description
`cpu_weight`	Positive integer	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. For details, refer to .

Considerations

A change applies to sessions that are already assigned to the resource group.
Changing one group’s cpu_weight changes the CPU share of every user-defined resource group, because each share is calculated from the sum of all weights.

Examples

The examples on this page use the following resource groups:

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

CREATE RESOURCE GROUP reporting WITH (cpu_weight = 100);

Change the CPU weight of a resource group

The following statement increases the CPU weight of the reporting group:

ALTER RESOURCE GROUP reporting WITH (cpu_weight = 200);

View the new CPU shares with . The share of oltp also changes, because the sum of the weights changed:

SHOW RESOURCE GROUPS;

  id |   name    | cpu_weight | max_cpu | cpu_share_percent
-----+-----------+------------+---------+--------------------
  17 | oltp      |        300 |    t    |                60
  18 | reporting |        200 |    f    |                40
(2 rows)

Change the `max_cpu` option of a resource group

The following statement sets max_cpu for the reporting group, so that the group stays in the burst tier when it uses more than its share. The group’s cpu_weight does not change:

ALTER RESOURCE GROUP reporting WITH (max_cpu = true);

View the group with SHOW RESOURCE GROUP:

SHOW RESOURCE GROUP reporting;

  id |   name    | cpu_weight | max_cpu | cpu_share_percent
-----+-----------+------------+---------+--------------------
  18 | reporting |        200 |    t    |                40
(1 row)

Statements

Syntax

Data Types

Spatial Data

Constraints

Required privileges

Synopsis

Parameters

Options

Considerations

Examples

Change the CPU weight of a resource group

Change the `max_cpu` option of a resource group

See also

​Required privileges

​Synopsis

​Parameters

​Options

​Considerations

​Examples

​Change the CPU weight of a resource group

​Change the max_cpu option of a resource group

​See also

Required privileges

Synopsis

Parameters

Options

Considerations

Examples

Change the CPU weight of a resource group

Change the `max_cpu` option of a resource group

See also