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