This has no solution for the issue but... On Tue, 7 Dec 2021 at 10:16, Klaudie Willis <Klaudie.Willis@xxxxxxxxxxxxxx> 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.
