| From: | Francisco Olarte <folarte(at)peoplecall(dot)com> |
|---|---|
| To: | Klaudie Willis <klaudie(dot)willis(at)protonmail(dot)com> |
| Cc: | "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: When Update balloons memory |
| Date: | 2021-12-07 12:40:58 |
| Message-ID: | CA+bJJbxndpy5pnJSEMTUUDAecS0YCJ5Xwtvf05vYq_8WFtVp4g@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs pgsql-general |
This has no solution for the issue but...
On Tue, 7 Dec 2021 at 10:16, Klaudie Willis
<Klaudie(dot)Willis(at)protonmail(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ian R. Campbell | 2021-12-07 12:51:45 | Fwd: range_agg() missing support for multirange inputs |
| Previous Message | Klaudie Willis | 2021-12-07 09:15:57 | When Update balloons memory |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2021-12-07 14:45:38 | Re: how to get value of parameter set in session for other user |
| Previous Message | Francisco Olarte | 2021-12-07 12:34:54 | Re: Query planner issue with preferring primary key over a better index when using ORDER BY and LIMIT |