负载管理参数

负载管理参数

下列配置参数配置Greenplum数据库负载管理特性(资源队列)、查询优先、内存利用和并发控制。

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