Workload Management Parameters

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

gp_resqueue_priority

gp_resqueue_priority_cpucores_per_ segment

gp_resqueue_priority_sweeper_ interval

gp_vmem_idle_resource_timeout

gp_vmem_protect_limit

gp_vmem_protect_segworker_cache_ limit

max_resource_queues

max_resource_portals_per_ transaction

resource_cleanup_gangs_on_ wait

resource_select_only

runaway_detector_activation_percent

stats_queue_level

vmem_process_interrupt