Re: Preventing OOM kills

From: Andrej <andrej(dot)groups(at)gmail(dot)com>
To: Yang Zhang <yanghatespam(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Preventing OOM kills
Date: 2011-05-25 00:50:09
Message-ID: BANLkTikNgmai4MKTBLk=YLP-xchKssBEsQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 25 May 2011 12:32, Yang Zhang <yanghatespam(at)gmail(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2011-05-25 00:53:33 Re: Preventing OOM kills
Previous Message Yang Zhang 2011-05-25 00:32:58 Preventing OOM kills