Help Center> GaussDB> Distributed_2.x> SQL Reference> SQL Syntax> ALTER APP WORKLOAD GROUP MAPPING

Updated on 2023-10-23 GMT+08:00

View PDF

ALTER APP WORKLOAD GROUP MAPPING

Function

ALTER APP WORKLOAD GROUP MAPPING modifies the workload group associated with an application mapping group. Only users who have the ALTER permission on the current database can modify application mapping group.

Precautions

None

Syntax

    
         ALTER APP WORKLOAD GROUP MAPPING app_name 
    WITH ( WORKLOAD_GPNAME = wg_name );

Parameter Description

app_name
Specifies the name of an application mapping group. The name of an application mapping group must be unique in the current database.

Value range: a string. It must comply with the naming convention.
wg_name
Specifies a Workload Cgroup name.

Value range: a string, which indicates the created workload group.

Examples

    
         -- Create a resource pool and specify the High Timeshare Workload Cgroup under the DefaultClass Cgroup.
openGauss=# CREATE RESOURCE POOL pool1 WITH (CONTROL_GROUP="High");

-- Create a workload group and associate it with the created resource pool.
openGauss=# CREATE WORKLOAD GROUP wg_hr1 USING RESOURCE POOL pool1;

-- Create a default application mapping group and associate it with the default workload group.
openGauss=# CREATE APP WORKLOAD GROUP MAPPING app_wg_map1;

-- Change the name of the workload group associated with an application mapping group.
openGauss=# ALTER APP WORKLOAD GROUP MAPPING app_wg_map1 WITH(WORKLOAD_GPNAME=wg_hr1);

-- Delete the application mapping group.
openGauss=# DROP APP WORKLOAD GROUP MAPPING app_wg_map1;

-- Delete the workload group.
openGauss=# DROP WORKLOAD GROUP wg_hr1;

-- Delete the resource pool.
openGauss=# DROP RESOURCE POOL pool1;