Resource Management Parameters

The following configuration parameters configure Greenplum Database 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
  
  

Parent topic: Configuration Parameter Categories