On Wed, Nov 2, 2011 at 10:42, David Kerr <d...@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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general