ALTER WORKLOAD GROUP

Function

ALTER WORKLOAD GROUP modifies a workload group and sets the number of concurrent SQL statements.

Precautions

Only a user with the ALTER permission on the current database can perform this operation.

Syntax

1
2

ALTER WORKLOAD GROUP wg_name
     USING RESOURCE POOL pool_name [ WITH ( ACT_STATEMENTS = count ) ];

Parameter Description

• wg_name

  Specifies the workload group name.

  

  The workload group must be unique in a database.

  Value range: a string. It must comply with the naming convention.

• pool_name

  Specifies the name of a resource pool.

  Value range: a string that indicates an existing resource pool

• counts

  Specifies the number of concurrent SQL statements in the resource pool that the workload group belongs to.

  Value range: an integer ranging from –1 to 2147483647

Examples

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12

-- Create a resource pool named pool1.
openGauss=# CREATE RESOURCE POOL pool1;

-- Create a workload group named group1.
openGauss=# CREATE WORKLOAD GROUP group1;

-- Change the maximum number of concurrent SQL statements in workload group group1 to 10. The workload group is associated with the resource pool pool1.
openGauss=# ALTER WORKLOAD GROUP group1 USING RESOURCE POOL pool1 WITH (ACT_STATEMENTS=10);

-- Delete workload group group1 and resource pool pool1.
openGauss=# DROP WORKLOAD GROUP group1;
openGauss=# DROP RESOURCE POOL pool1;

Helpful Links

CREATE WORKLOAD GROUP and DROP WORKLOAD GROUP