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
| 