public inbox for [email protected]  
help / color / mirror / Atom feed
From: Joe Conway <[email protected]>
To: Siraj G <[email protected]>
To: [email protected]
Subject: Re: Help in dealing with OOM
Date: Mon, 14 Oct 2024 15:08:58 -0400
Message-ID: <[email protected]> (raw)
In-Reply-To: <CAC5iy61r=0hQ=jnFtr4r1uZuw1i=ZF32EiS53AhpEFBhwkOHbA@mail.gmail.com>
References: <CAC5iy61r=0hQ=jnFtr4r1uZuw1i=ZF32EiS53AhpEFBhwkOHbA@mail.gmail.com>

On 10/14/24 14:37, Siraj G wrote:
> This is from the OS log (/var/log/kern.log):
> 
> oom- 
> kill:constraint=CONSTRAINT_NONE,nodemask=(null),cpuset=/,mems_allowed=0,global_oom,task_memcg=/system.sli      ce/system-postgresql.slice/[email protected],task=postgres,pid=2334587,uid=114
>    494 Oct 14 09:58:10 gce-k12-prod-as1-erp-pg-secondary kernel: 
> [6905020.514569] Out of memory: Killed process 2334587 (postgres) total- 
> vm:26349584kB, anon-rss:3464kB, file-rss:0kB, shmem-rs     
>   s:21813032kB, UID:114 pgtables:49024kB oom_score_adj:0


1. Do you happen to have swap disabled? If so, don't do that.

2. Does the postgres cgroup have memory.limit (cgroup v1) or memory.max
    (cgroup v2) set?

3. If #2 answer is no, have you followed the documented guidance here
    (in particular vm.overcommit_memory=2):

  
https://www.postgresql.org/docs/12/kernel-resources.html#LINUX-MEMORY-OVERCOMMIT


-- 
Joe Conway
PostgreSQL Contributors Team
RDS Open Source Databases
Amazon Web Services: https://aws.amazon.com






view thread (3+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re: Help in dealing with OOM
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox