Preventing OOM kills - Mailing list pgsql-general

From Yang Zhang
Subject Preventing OOM kills
Date
Msg-id BANLkTikLz2YMS5GmUKQgMrYpFyHwZS687g@mail.gmail.com
Whole thread Raw
Responses Re: Preventing OOM kills
Re: Preventing OOM kills
List pgsql-general
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.

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Values larger than 1/3 of a buffer page cannot be indexed (hstore)
Next
From: Andrej
Date:
Subject: Re: Preventing OOM kills