After allocating system resources using resource pools, you must associate tasks with resource pools for service load management.
After a resource pool is associated with a user, all the tasks of the user are automatically associated with the resource pool.
- Create a resource pool respool associated with the default Cgroup.
CREATE RESOURCE POOL respool; CREATE RESOURCE POOL
You can associate the resource pool with a user-defined Cgroup as required. For details, see Resource Pools.
- Create user user1 and associate the user with the respool resource pool.
CREATE USER user1 WITH RESOURCE POOL 'respool' password 'password';
- Run job.sql as user user1.
gsql -U user1 -W password -d gaussdb -p 8000 -f job.sql
Alternatively, connect to the related database as user user1 and run the task.
gsql -U user1 -W password -d gaussdb -p 8000