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