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.
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 |