gp_vmem_protect_limit

gp_vmem_protect_limit

Sets the amount of memory (in number of MBs) that all postgres processes of an active segment instance can consume. If a query causes this limit to be exceeded, memory will not be allocated and the query will fail.

Note that this is a local parameter and must be set for every segment in the system (primary and mirrors).

To prevent over allocation of memory, this calculation can estimate a gp_vmem_protect_limit value that is applicable in a wide variety of situations:

(SWAP + (RAM * vm.overcommit_ratio)) .9 /number_segments_per_server

For example, on a segment host with 8GB of swap space, 128GB physical memory, 8 primary segment instances, and a 10% buffer, the calculation would be:

(8 + (128 * .5) * .9 / 8 = 8GB = 8192MB
Note: The default value for the operating system parameter vm.overcommit_ratio is .5.
Value Range Default Set Classifications
integer 8192 local

system

restart