On 9/5/22 07:54, liam saffioti wrote:
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