Re: Getting out ahead of OOM

From: Rui DeSousa <rui(dot)desousa(at)icloud(dot)com>
To: Joseph Hammerman <joe(dot)hammerman(at)datadoghq(dot)com>
Cc: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: Getting out ahead of OOM
Date: 2025-03-07 20:17:37
Message-ID: F71FFCF6-19D1-49D2-8286-B71903373A9B@icloud.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-admin

> On Mar 7, 2025, at 2:07 PM, Joseph Hammerman <joe(dot)hammerman(at)datadoghq(dot)com> wrote:
>
> Has anyone had success tracking all the Postgres memory allocation configurables and using that to administratively prevent OOMing?

Don’t use memory limits in Kubernetes and we also run Postgres on dedicated Kubernetes clusters.

Shared memory will get counted multiple times. Each login session; as it maps in the shared buffers, it will get wrongly counted as memory used (it is shared memory!).

I have instances running on Kubernetes that only use 6GB of memory; however Kubernetes is wrongly reporting 50GB used due to number of active seasons. Our Postgres pods use to get terminated when “exceeding" the limit but not! Until removed the use of memory limits in Kubernetes.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Joe Conway 2025-03-09 20:37:20 Re: Getting out ahead of OOM
Previous Message Tom Lane 2025-03-07 19:26:03 Re: Getting out ahead of OOM