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 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 WITH RESOURCE POOL 'respool' password 'Bigdata@123'; CREATE ROLE
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