MIME-Version: 1.0
References: <CADX_1ab6U-T_SZP7L1uiOMNdBm9vV07u22i-KgQvu1E=BHguWA@mail.gmail.com>
In-Reply-To: <CADX_1ab6U-T_SZP7L1uiOMNdBm9vV07u22i-KgQvu1E=BHguWA@mail.gmail.com>
From: Ron Johnson <ronljohnsonjr@gmail.com>
Date: Mon, 17 Nov 2025 13:16:14 -0500
Message-ID: <CANzqJaDcNFW8kSMVw3oCvzsq=GLZxpmbS2gkc1fkh1-f_QgLAA@mail.gmail.com>
Subject: Re: postgres in swap space
To: "pgsql-general@lists.postgresql.org" <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="00000000000063dec20643ce5899"
Archived-At: <https://www.postgresql.org/message-id/CANzqJaDcNFW8kSMVw3oCvzsq%3DGLZxpmbS2gkc1fkh1-f_QgLAA%40mail.gmail.com>
Precedence: bulk

--00000000000063dec20643ce5899
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Mon, Nov 17, 2025 at 12:25=E2=80=AFPM Marc Millas <marc.millas@mokadb.co=
m> wrote:

> hello,
> Can someone point me to any doc describing why and how much space postgre=
s
> 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.

--=20
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!

--00000000000063dec20643ce5899
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr">On Mon, Nov 17, 2025 at 12:25=E2=80=AFPM =
Marc Millas &lt;<a href=3D"mailto:marc.millas@mokadb.com">marc.millas@mokad=
b.com</a>&gt; wrote:</div><div class=3D"gmail_quote gmail_quote_container">=
<blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-=
left:1px solid rgb(204,204,204);padding-left:1ex"><div dir=3D"ltr"><div>hel=
lo,<br clear=3D"all"></div><div>Can someone point me to any doc describing =
why and how much=C2=A0space postgres uses on the swap of a debian machine ?=
</div><div>it&#39;s an old postgres 10, because it is used by a product for=
 which only this version is certified.</div><div>(no comment on that, pleas=
e)</div></div></blockquote><div>=C2=A0</div></div><div>Swap as in RAM swap =
space?=C2=A0 If so, then it uses as much or as little as Linux thinks needs=
 to be used, given the amount of RAM.</div><div><br></div><div>effective_ca=
che_size,=C2=A0work_mem,=C2=A0shared_buffers, maintenance_work_mem,=C2=A0ma=
x_worker_* and=C2=A0max_parallel_* affect how much RAM PG uses, in conjunct=
ion with the number of active connections (including maintenance work).</di=
v><div><br></div><div><a href=3D"https://postgresqlco.nf/doc/en/param/">htt=
ps://postgresqlco.nf/doc/en/param/</a> is a handy resource.</div><div><br><=
/div><span class=3D"gmail_signature_prefix">-- </span><br><div dir=3D"ltr" =
class=3D"gmail_signature"><div dir=3D"ltr">Death to &lt;Redacted&gt;, and b=
utter sauce.<div>Don&#39;t boil me, I&#39;m still alive.<br><div><div>&lt;R=
edacted&gt; lobster!</div></div></div></div></div></div>

--00000000000063dec20643ce5899--