Workload Management Parameters

A newer version of this documentation is available. Use the version menu above to view the most up-to-date release of the Greenplum 4.x documentation.

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