Updated at: 2022-08-03 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.

    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.

    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

close