Warning on vm.overcommit

[DharveshAtish]

the script postgresqltuner.pl suggestion about vm.overcommit_ratio is inexact. example of line warning about vm.overcommit_ratio : [BAD] vm.overcommit_ratio is too low, you will not be able to use more than (50/100)*RAM+SWAP for applications

/proc/sys/vm/overcommit_memory in my env at that time is set to 0 , and this setting is only used when overcommit_memory = 2.

2: The Linux kernel will not overcommit memory, and only allocate as much memory as defined in overcommit_ratio.

Expected Behavior

Current Behavior

Possible Solution

check /proc/sys/vm/overcommit_memory if set to 2 before throwing warning about vm.overcommit_ratio is too low or high.

Steps to Reproduce (for bugs)

Context

Your Environment

• Version used:
• PostgreSQL version: 9.3.5
• Operating System and version: CentOS release 6.10 Kernel 2.6.32-754.25.1.el6.x86_64