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/postgresql@12-main.service,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
