Re: Preventing OOM kills - Mailing list pgsql-general

From Andrej
Subject Re: Preventing OOM kills
Date
Msg-id BANLkTikNgmai4MKTBLk=YLP-xchKssBEsQ@mail.gmail.com
Whole thread Raw
In response to Preventing OOM kills  (Yang Zhang <yanghatespam@gmail.com>)
Responses Re: Preventing OOM kills  (Scott Marlowe <scott.marlowe@gmail.com>)
Re: Preventing OOM kills  (John R Pierce <pierce@hogranch.com>)
List pgsql-general
On 25 May 2011 12:32, Yang Zhang <yanghatespam@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.


Cheers,
Andrej

pgsql-general by date:

Previous
From: Yang Zhang
Date:
Subject: Preventing OOM kills
Next
From: Scott Marlowe
Date:
Subject: Re: Preventing OOM kills