Content-Type: multipart/alternative;
 boundary="------------0rAGwVNwMQZgvzGvKFzjP1zE"
Date: Mon, 17 Nov 2025 15:23:45 -0500
MIME-Version: 1.0
Subject: Re: postgres in swap space
In-Reply-To: 
 <CADX_1ab6U-T_SZP7L1uiOMNdBm9vV07u22i-KgQvu1E=BHguWA@mail.gmail.com>
Content-Transfer-Encoding: 7bit
From: pg254kl@georgiou.vip
To: "pgsql-general@lists.postgresql.org" <pgsql-general@lists.postgresql.org>
Message-ID: <176341102890.7.18257482502754438507.1011873319@georgiou.vip>
References: 
 <CADX_1ab6U-T_SZP7L1uiOMNdBm9vV07u22i-KgQvu1E=BHguWA@mail.gmail.com>
Archived-At: <https://www.postgresql.org/message-id/176341102890.7.18257482502754438507.1011873319%40georgiou.vip>
Precedence: bulk

This is a multi-part message in MIME format.
--------------0rAGwVNwMQZgvzGvKFzjP1zE
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: quoted-printable

Putting memory pages to swap is the decision of the linux virtual memory=20
manager not postgres.=C2=A0 If your db machine is swapping, first make su=
re=20
you have set sensible values for the ram related settings like=20
shared_buffers (25%), effective_cache_size (75%) and work_mem (keep it=20
modest at 4 to 16 MB).

On 11/17/25 12:25 PM, Marc Millas - marc.millas at mokadb.com wrote:
> hello,
> Can someone point me to any doc describing why and how much=C2=A0space=20
> postgres uses on the swap of a debian machine ?
> it's an old postgres 10, because it is used by a product for which=20
> only this version is certified.
> (no comment on that, please)
>
> regards
>
> Marc MILLAS
> Senior Architect
> +33607850334
> www.mokadb.com <http://www.mokadb.com>
>
--=20
regards,
Kiriakos Georgiou

--------------0rAGwVNwMQZgvzGvKFzjP1zE
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE html>
<html>
  <head>
    <meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3DUTF=
-8">
  </head>
  <body>
    <p>Putting memory pages to swap is the decision of the linux virtual
      memory manager not postgres.=C2=A0 If your db machine is swapping,
      first make sure you have set sensible values for the ram related
      settings like shared_buffers (25%), effective_cache_size (75%) and
      work_mem (keep it modest at 4 to 16 MB).=C2=A0=C2=A0</p>
    <div class=3D"moz-cite-prefix">On 11/17/25 12:25 PM, Marc Millas -
      marc.millas at mokadb.com wrote:<br>
    </div>
    <blockquote type=3D"cite"
cite=3D"mid:CADX_1ab6U-T_SZP7L1uiOMNdBm9vV07u22i-KgQvu1E=3DBHguWA@mail.gm=
ail.com">
      <meta http-equiv=3D"content-type" content=3D"text/html; charset=3DU=
TF-8">
      <div dir=3D"ltr">
        <div>hello,<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'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, please)</div>
        <div><br>
        </div>
        <div>regards</div>
        <div><br>
        </div>
        <div>
          <div dir=3D"ltr" class=3D"gmail_signature"
            data-smartmail=3D"gmail_signature">
            <div dir=3D"ltr">
              <div>
                <div dir=3D"ltr">Marc MILLAS
                  <div>Senior Architect</div>
                  <div>+33607850334</div>
                  <div><a href=3D"http://www.mokadb.com" target=3D"_blank=
"
                      moz-do-not-send=3D"true">www.mokadb.com</a></div>
                  <div><br>
                  </div>
                </div>
              </div>
            </div>
          </div>
        </div>
      </div>
    </blockquote>
    <pre class=3D"moz-signature" cols=3D"72">--=20
regards,
Kiriakos Georgiou</pre>
  </body>
</html>

--------------0rAGwVNwMQZgvzGvKFzjP1zE--