Skip to content

Warning on vm.overcommit #74

Open
Open
@DharveshAtish

Description

@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

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions