Postgres Pro
Downloads
Home   >   mailing lists

Re: OOM Killer kills PostgreSQL - Mailing list pgsql-performance

From Stephen Frost
Subject Re: OOM Killer kills PostgreSQL
Date
Msg-id 20200520165419.GH3418@tamriel.snowman.net
Whole thread Raw
In response to OOM Killer kills PostgreSQL  (Piotr Włodarczyk <piotrwlodarczyk89@gmail.com>)
List pgsql-performance
Tree view 
Greetings,

* Piotr Włodarczyk (piotrwlodarczyk89@gmail.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
Attachment

pgsql-performance by date:

Previous
From: Justin Pryzby
Date:
Subject: Re: OOM Killer kills PostgreSQL
Next
From: postgann2020 s
Date:
Subject: Suggestion to improve query performance for GIS query.