Re: When Update balloons memory

Поиск
Список
Период
Сортировка
От Francisco Olarte
Тема Re: When Update balloons memory
Дата
Msg-id CA+bJJbxndpy5pnJSEMTUUDAecS0YCJ5Xwtvf05vYq_8WFtVp4g@mail.gmail.com
обсуждение исходный текст
Ответ на When Update balloons memory  (Klaudie Willis <Klaudie.Willis@protonmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Francisco Olarte
Дата:
Сообщение: Re: Query planner issue with preferring primary key over a better index when using ORDER BY and LIMIT
Следующее
От: Tom Lane
Дата:
Сообщение: Re: how to get value of parameter set in session for other user