Updated on 2022-08-16 GMT+08:00

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 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