Greenplum: Important Queries to Configure the Resource Queue (Workload Management)

This article is half-done without your Comment! *** Please share your thoughts via Comment ***

Create an RQ with Statement Limit:
It will allow an only specified number of active statement for particular RQ.

Create an RQ with Memory Limit:
The Memory restriction all the queries which submitted through the RQ.

Create an RQ with Query Execution Planner cost Limit:
You can set a limit of Query Execution Planner cost where some active statements are not required and N number of sessions can run until it reaches to MAX_COST.

Set Priorities:
You can set any priority level from this list: LOW, MEDIUM, HIGH, MAX

Assign Roles to RQ:
Create:

Alter:

Remove Role from RQ: