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, so it interrupts lots of transactions.
I wonder if a GUC can be implemented, so it could fail just a single backend by limiting its memory use. For instance: max_mememory_per_backend=100MiB. The idea is to increase stability by limiting each process. Of course it would result in "out of memory" in case a single query requires 100500MiB (e.g. it misunderestimates the hash join). As far as I understand, it should be safer to terminate just one bad backend rather than kill all the processes. I did some research, and I have not found the discussion of this idea. Vladimir Rusinov> FWIW, lack of per-connection and/or global memory limit for work_mem is major PITA > https://www.postgresql.org/message-id/CAE1wr-ykMDUFMjucDGqU-s98ARk3oiCfhxrHkajnb3f%3DUp70JA%40mail.gmail.com Vladimir
