Re: OOM Killer kills PostgreSQL

From: Stephen Frost <sfrost(at)snowman(dot)net>
To: Piotr Włodarczyk <piotrwlodarczyk89(at)gmail(dot)com>
Cc: pgsql-performance(at)lists(dot)postgresql(dot)org
Subject: Re: OOM Killer kills PostgreSQL
Date: 2020-05-20 16:54:19
Message-ID: 20200520165419.GH3418@tamriel.snowman.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Greetings,

* Piotr Włodarczyk (piotrwlodarczyk89(at)gmail(dot)com) wrote:
> We met unexpected PostgreSQL shutdown. After a little investigation we've
> discovered that problem is in OOM killer which kills our PostgreSQL.

You need to configure your system to not overcommit.

Read up on overcommit_ratio and overcommit_memory Linux settings.

Thanks,

Stephen

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message postgann2020 s 2020-05-20 18:20:53 Suggestion to improve query performance.
Previous Message Justin Pryzby 2020-05-20 08:46:38 Re: OOM Killer kills PostgreSQL