Postgres Pro
Downloads
Home   >   mailing lists

Re: max_memory_per_backend GUC to limit backend's memory usage - Mailing list pgsql-hackers

From Andres Freund
Subject Re: max_memory_per_backend GUC to limit backend's memory usage
Date
Msg-id 20180323160653.xmwf2ci3lwzlru6g@alap3.anarazel.de
Whole thread Raw
In response to max_memory_per_backend GUC to limit backend's memory usage  (Vladimir Sitnikov <sitnikov.vladimir@gmail.com>)
List pgsql-hackers
Tree view 
Hi,

On 2018-03-23 15:58:55 +0000, Vladimir Sitnikov wrote:
> I've got a problem with PostgreSQL 9.6.5: backend gets killed by OOM
> killer, and it shuts the DB down.
> Of course, the OOM case is to be investigated (MemoryContextStatsDetail,
> etc), however I wonder if DB can be more robust.

Configuring overcommit_memory to not overcommit should do the trick.

Greetings,

Andres Freund

pgsql-hackers by date:

Previous
From: Vladimir Sitnikov
Date:
Subject: max_memory_per_backend GUC to limit backend's memory usage
Next
From: Konstantin Knizhnik
Date:
Subject: Re: [HACKERS] Surjective functional indexes