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. Cheers, Andrej -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
