《GPDB管理员笔记(五)GP系统配置》(https://www.unjs.com)。可以通过调整gp_vmem_protect_limit避免运行查询处理时Segment主机出现内存溢出。 gp_vmem_idle_resource_timeout gp_vmem_protect_limit gp_vmem_protect_segworker_cache_limit max_appendonly_tables max_prepared_transactions...
[name: gp_vmem_protect_segworker_cache_limit] [unit: ] [context: postmaster] [vartype: integer] [min_val: 1] [max_val: 1073741823] [name: gp_workfile_checksumming] [unit: None] [context: user] [vartype: bool] [min_val: None] [max_val: None] [name: gp_workfile_compress_algorith...