What should an application do if they get an “out of memory” error?

posted Jan 4, 2015, 6:55 AM by Sachchida Ojha   [ updated Jan 4, 2015, 7:11 AM ]
The gadget spec URL could not be found

For example:
Out of memory (seg27 host.greenplumdba.com pid=47093)
VM Protect failed to allocate 4096 bytes, 0 MB available

The gadget spec URL could not be found

Here are the possible solutions:
  1.  Tune query to require less memory
  2.  Reduce query concurrency using a resource queue
  3.  Decrease the number of segments per host in the GP cluster
  4.  Increase memory on the host
  5.  Validate gp_vmem_protect_limit at the database level, see calculations below for maximum safe settings
  6.  Use a session setting to reduce the statement_mem used by specific queries
  7.  Decrease statement_mem at the database level
  8.  Set the memory quota on a resource queue to limit the memory used by queries executed within the resource queue
The gadget spec URL could not be found
The gadget spec URL could not be found

Ċ
GPDBMemorySettingsWhitePaper.pdf
(113k)
Sachchida Ojha,
Jan 4, 2015, 7:14 AM
v.1
Comments