On Tue, May 24, 2011 at 6:50 PM, Andrej <andrej.groups@xxxxxxxxx> wrote: > On 25 May 2011 12:32, Yang Zhang <yanghatespam@xxxxxxxxx> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
