On Wed, Nov 2, 2011 at 10:42, David Kerr <dmk@mr-paradox.net> wrote:
> Howdy,
>
> just a quick check, is
> vm.overcommit_memory = 2
> vm.swappiness = 0
>
> Still the way to go with PG9.0 / RHEL 6.1 (64bit) ?
IMHO yes (although I never touch swappiness...)
> I know we gained some control over the OOM Killer in newer kernels
> and remember reading that maybe postgres could handle it in a different way now.
If you compile with -DOOM_ADJ (which I think the red hat rpms do?)
yes. As usual the docs are fairly good:
http://www.postgresql.org/docs/9.1/interactive/kernel-resources.html#LINUX-MEMORY-OVERCOMMIT