Workload Management Configuration Parameters in Greenplum

The following configuration parameters are used to configure the Greenplum Database workload management feature (resource queues), query prioritization, memory utilization and concurrency control.

1. gp_resqueue_priority

2. gp_resqueue_priority_cpucores_per_segment

3. gp_resqueue_priority_sweeper_interval

4. gp_vmem_idle_resource_timeout

5. gp_vmem_protect_limit

6. gp_vmem_protect_segworker_cache_limit

7. max_resource_queues

8. max_resource_portals_per_transaction

9. resource_cleanup_gangs_on_wait

10. resource_select_only

11. stats_queue_level