Re: Postgres server crash

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Richard Troy wrote:
I did that - spent about two f-ing hours looking for what I wanted. (Guess
I entered poor choices for my searches. -frown- ) There are a LOT of
articles that TALK ABOUT OOM, but prescious few actually tell you what you
can do about it.

Trying to save you some time:

On linux you can use the sysctl utility to muck with vm.overcommit_memory;
You can disable the "feature."

Google _that_ for more info!


Here's something I found googling for "memory overcommitment"+linux

 http://archives.neohapsis.com/archives/postfix/2000-04/0512.html

 From /usr/src/linux/Documentation/sysctl/vm.txt

 "overcommit_memory:

 This value contains a flag that enables memory overcommitment.
 When this flag is 0, the kernel checks before each malloc()
 to see if there's enough memory left. If the flag is nonzero,
 the system pretends there's always enough memory."

 This flag is settable in /proc/sys/vm

Lo and behold, here it is on my system:

  $ cat /proc/sys/vm/overcommit_memory
  0
$ cat /proc/sys/vm/overcommit_ratio 50

Craig


[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux