Help Center/ GaussDB(DWS)/ More Documents/ Developer Guide (ME-Abu Dhabi Region)/ Resource Load Management/ Basic Framework for Resource Load Management/ Associated Jobs
Updated on 2022-06-11 GMT+08:00
View PDF
Share

Associated Jobs

Context

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.

Procedure

  1. Create a resource pool respool associated with the default Cgroup. 

    1
2
    		 
    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.

  2. Create user user1 and associate the user with the respool resource pool. 

    1
    		 
    CREATE USER user1 WITH RESOURCE POOL 'respool' password 'password';

  3. Run job.sql as user user1. 

    gsql -U user1 -W password -d postgres -p 8000 -f job.sql

    Alternatively, connect to the related database as user user1 and run the task.

    gsql -U user1 -W password -d postgres -p 8000