We have migrated to new Google sites!
Post date: Jan 04, 2015 2:55:14 PM
For example:
Out of memory (seg27 host.greenplumdba.com pid=47093)
VM Protect failed to allocate 4096 bytes, 0 MB available
Here are the possible solutions:
Tune query to require less memory
Reduce query concurrency using a resource queue
Decrease the number of segments per host in the GP cluster
Increase memory on the host
Validate gp_vmem_protect_limit at the database level, see calculations below for maximum safe settings
Use a session setting to reduce the statement_mem used by specific queries
Decrease statement_mem at the database level
Set the memory quota on a resource queue to limit the memory used by queries executed within the resource queue