• Data Warehouse Service

dws
  1. Help Center
  2. Data Warehouse Service
  3. Developer Guide
  4. Resource Load Management
  5. Resource Load Management Framework Overview
  6. Association Tasks

Association Tasks

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

    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 'Bigdata@123';
    CREATE ROLE

  3. Run job.sql as user user1.

    gsql -U user1 -W Bigdata@123 -d postgres -p 8000 -f job.sql

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

    gsql -U user1 -W Bigdata@123 -d postgres -p 8000