On Tue, May 24, 2011 at 6:50 PM, Andrej <andrej.gro...@gmail.com> wrote: > On 25 May 2011 12:32, Yang Zhang <yanghates...@gmail.com> wrote: >> PG tends to be picked on by the Linux OOM killer, so lately we've been >> forcing the OOM killer to kill other processes first with this script: >> >> while true; do >> for i in `pgrep postgres`; do >> echo -17 > /proc/$i/oom_adj >> done >> sleep 60 >> done >> >> Is there a Better Way? Thanks in advance. > > Add more RAM? Look at tunables for other processes on > the machine? At the end of the day making the kernel shoot > anything out of despair shouldn't be the done thing.
I thought that setting vm.overcommit_memory=2 stopped the OOM killer. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general