Enabling Resource Load Management

Background

This section describes how to configure parameters for resource load management.

Prerequisites

In openGauss, you can manage system resources only as a database administrator. Run the following statement to query user permissions:
```
openGauss=# SELECT rolname FROM pg_roles WHERE rolsystemadmin = 't';
 rolname
---------
 omm
 Jack
(2 rows)
```
Resource load management can be applied only to users with the login permission. Run the following statement to query user permissions:
```
openGauss=# SELECT rolname FROM pg_roles WHERE rolcanlogin = 't';
 rolname
---------
 omm
(1 row)
```

NOTICE: If a user's login permission is revoked, the user's resource pool will be changed to default_pool. For details about default_pool, see Table 2.

Procedure

You can perform the following steps only as a database administrator to enable load management based on the resource pool. The following uses user omm as an example.

Enable resource pool–based load management.

gs_guc set -N all -I all -c "use_workload_manager=on"

Restart the database for the parameter settings to take effect.
```
gs_om -t stop && gs_om -t start
```