Greenplum gp_vmem_protect_limit 出错

运行的Greenplum报这个错:

‘53400’, ‘[53400] ERROR: Out of memory  (seg30 slice3 bbsod:40002 pid=26372)\\\\nVM Protect failed to allocate 8388608 bytes, 6 MB available;\\\\nError while executing the query (7)
psql进入查看show gp_vmem_protect_limit 为8096,单位是kb。重设这个参数: gpconfig -c gp_vmem_protect_limit -v 1048576并记住要重启服务gpstop -r

作者: hqiang1984

量化自我,极简主义