The attached is a doc patch for Linux memory overcommit and an additional way of
avoiding a problem that postmaster is suddenly killed by OOM-Killer.
http://archives.postgresql.org/pgsql-docs/2007-03/msg0.php
Best regards,
--
Toru SHIMOGAKI<[EMAIL PROTECTED]>
*** runtime.sgml.orig 2007-03-06 16:23:10.0 +0900
--- runtime.sgml2007-03-06 17:14:38.0 +0900
***
*** 1207,1215
! On Linux 2.6 and later, a better solution is to modify the kernel's
! behavior so that it will not overcommit memory. This is
! done by selecting strict overcommit mode via sysctl:
sysctl -w vm.overcommit_memory=2
--- 1207,1224
! In addition, increasing swap area on OS can avoid the problem too.
! Out-of-Memory-Killer(OOM-Killer) is invoked whenever physical memory and
! swap area are exhausted. Increasing swap area is easy to set and it
! doesn't have harmful influence.
!
!
!
! On Linux 2.6 and later, a better solution is to modify the kernel's
! behavior so that it will not overcommit memory. Though this
! setting can't prevent OOM-Killer from invoking directly, we can expect
! healty memory allocation. This is done by selecting strict overcommit
! mode via sysctl:
sysctl -w vm.overcommit_memory=2
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
