Re: postgres in swap space
Ron Johnson <ronljohnsonjr@gmail.com>
From: Ron Johnson <ronljohnsonjr@gmail.com>
To: "pgsql-general@lists.postgresql.org" <pgsql-general@lists.postgresql.org>
Date: 2025-11-17T18:16:14Z
Lists: pgsql-general
On Mon, Nov 17, 2025 at 12:25 PM Marc Millas <marc.millas@mokadb.com> wrote: > hello, > Can someone point me to any doc describing why and how much space postgres > uses on the swap of a debian machine ? > it's an old postgres 10, because it is used by a product for which only > this version is certified. > (no comment on that, please) > Swap as in RAM swap space? If so, then it uses as much or as little as Linux thinks needs to be used, given the amount of RAM. effective_cache_size, work_mem, shared_buffers, maintenance_work_mem, max_worker_* and max_parallel_* affect how much RAM PG uses, in conjunction with the number of active connections (including maintenance work). https://postgresqlco.nf/doc/en/param/ is a handy resource. -- Death to <Redacted>, and butter sauce. Don't boil me, I'm still alive. <Redacted> lobster!