Re: PostgreSQL Out of Memory

Hi Teams,

FATAL:  terminating background worker "parallel worker" due to administrator command

FATAL:  terminating background worker "parallel worker" due to administrator command

FATAL:  terminating background worker "parallel worker" due to administrator command

FATAL:  out of memory

FATAL:  out of memory

...

You are allowing over-committing memory, which in turn activates OOMK (Out of Memory Killer) when the memory runs out. You have to restrict the number of connections or parameters like work_mem and hash_mem_multiplier. There is also a good article on Squishy Data:

https://www.crunchydata.com/blog/deep-postgresql-thoughts-the-linux-assassin

Basically, you should start with vm.overcommit_memory = 2

-- 
Mladen Gogala
Database Consultant
Tel: (347) 321-1217
https://dbwhisperer.wordpress.com