Re: PostgreSQL Out of Memory

Mladen Gogala <gogala.mladen@xxxxxxxxx> · Mon, 5 Sep 2022 11:25:55 -0400



    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