Re: When Update balloons memory - Mailing list pgsql-general

From Francisco Olarte
Subject Re: When Update balloons memory
Date
Msg-id CA+bJJbxndpy5pnJSEMTUUDAecS0YCJ5Xwtvf05vYq_8WFtVp4g@mail.gmail.com
Whole thread Raw
In response to When Update balloons memory  (Klaudie Willis <Klaudie.Willis@protonmail.com>)
List pgsql-general
This has no solution for the issue but...

On Tue, 7 Dec 2021 at 10:16, Klaudie Willis
<Klaudie.Willis@protonmail.com> wrote:
> Ubuntu 20.04, 64GB ram, 16GB shared buffer, 500 MB working mem, Postgresql 14.1
...
> shared_buffers = 16GB
> effective_cache_size = 48GB
... You are not going to have total ram - shared buffers in the cache,
os, postgres, work mem, other processess and all sort of different
things eat ram. I would suggest looking at free/top/whatever too size
this ( it should not OOM, just distort pg estimates ).

Francisco Olarte.



pgsql-general by date:

Previous
From: Francisco Olarte
Date:
Subject: Re: Query planner issue with preferring primary key over a better index when using ORDER BY and LIMIT
Next
From: Tom Lane
Date:
Subject: Re: how to get value of parameter set in session for other user