Re: postgres in swap space

From: Ron Johnson <ronljohnsonjr(at)gmail(dot)com>
To: "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: postgres in swap space
Date: 2025-11-17 18:16:14
Message-ID: CANzqJaDcNFW8kSMVw3oCvzsq=GLZxpmbS2gkc1fkh1-f_QgLAA@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, Nov 17, 2025 at 12:25 PM Marc Millas <marc(dot)millas(at)mokadb(dot)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!

In response to

Browse pgsql-general by date

  From Date Subject
Next Message pg254kl 2025-11-17 20:23:45 Re: postgres in swap space
Previous Message Marc Millas 2025-11-17 17:25:14 postgres in swap space