Re: max_memory_per_backend GUC to limit backend's memory usage

2018-03-23 Thread Andres Freund
Hi, On 2018-03-23 15:58:55 +, 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. Confi

max_memory_per_backend GUC to limit backend's memory usage

2018-03-23 Thread Vladimir Sitnikov
Hi, 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. The sad thing is a single backend crash results in the DB shutdown, s