Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vL9Rq-005leA-2m for pgsql-general@arkaria.postgresql.org; Tue, 18 Nov 2025 00:19:55 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vL9Qp-002qmY-29 for pgsql-general@arkaria.postgresql.org; Tue, 18 Nov 2025 00:18:51 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vL9Qp-002qmQ-0a for pgsql-general@lists.postgresql.org; Tue, 18 Nov 2025 00:18:51 +0000 Received: from mail-oo1-xc34.google.com ([2607:f8b0:4864:20::c34]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1vL9Qm-0004iB-28 for pgsql-general@lists.postgresql.org; Tue, 18 Nov 2025 00:18:50 +0000 Received: by mail-oo1-xc34.google.com with SMTP id 006d021491bc7-656b8ca52e8so2141636eaf.3 for ; Mon, 17 Nov 2025 16:18:49 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1763425128; x=1764029928; darn=lists.postgresql.org; h=to:subject:message-id:date:from:in-reply-to:references:mime-version :from:to:cc:subject:date:message-id:reply-to; bh=TS7QGiwvVfC19Bxe7pJwjCCAtZriRhFVb7TT+zymjzk=; b=A8xSFcOGQMwUauwRo6jBjDbMfK5/ZDLAvH9KuCJw9tR2/7hXv3b1RDBdQ1ae7p9wDc qcwypFMLtITcu+3QzDhJdpUKP9DJdpP3ZRbQPAaHGs5kTx4b4OlsSOGrpqjdiOpOdsyQ T8zlE2GDfYV9zAVGJXok0TzUry7lTQwNVMYN6X5JhzaQEE8U8V3sJ7I3/0p0mZRofz9q Vi67ooHuyZzrIYLcreugXcBNSCUzs/a5zH9UocLmS2fp0+OxvzzwfIch0zhToVCEn16Y lTlcoEPg+NEmhBcS6H9qB76qVGunp9zhTmjPkaiwVNBuai3ZxBpJFU42we2aFi4Ethj8 ayag== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1763425128; x=1764029928; h=to:subject:message-id:date:from:in-reply-to:references:mime-version :x-gm-gg:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=TS7QGiwvVfC19Bxe7pJwjCCAtZriRhFVb7TT+zymjzk=; b=gLh4JNN9O1yIUKHbTtt2vrUdBQ4EhESfYWLLVRnochJgAtj6O/13TzcmaSks09GPtc 0T8n/iNJrJCEgbvwBVr49NlPItYKCfZa4eGVSvqDYGxkuBhOlT5URagJSB4B6vHExPgY rIjUq94yyqpBfOVKcHTA0Aj42/XSFKQHHxsJDYcr5n2n1+5lzzPoVzoELm35WPYY8i6V HY3s0Qw4+8Ose7oDmbRCSSwOEP91luas3X6UYc2zhIt6qv9MTBnMKhOYC9CKhsKnW4vp p/FvU2/XMSp9I3CubuBkLb3nf7XdfY56rMEiShywGic2ldTT1/zn8/u26DPR2EZ+Ugkv Cw6Q== X-Gm-Message-State: AOJu0YzicqOJpF62snSe6399gc5jUbnel1ATbUjjBxfuqGB69pBsBTrP GmXjDCi+wFekF/G+8owPVNZEEGPy8nZiv6bs+HoVrwpbfxmIPnponxXVf3URQMthI+lE6ZxWlNz 6/IO1XHAmAMwTXCmxMjW8+21TS9QmuL4tgA== X-Gm-Gg: ASbGncu6svcEtrSh4T8DHG4idmBVLDt9ISTdAz+Wahz53jjhGwfXX60zA7LRKtTOArj YBT5Owzh8/fqOV/31nzkHhDr3tNyWxTK6qyNLUcVYA02apzx9N9kcZhIcf0NDuHKRDV4HpB3RKr 5EqAVAEQBvvt8+XpgTtvL01GNorFdeSg5Lo7IkKkIilGiW8X2hIEDkDrRsDMuhBfy8ozUDVUmJU m3IfLihKJ32nOx6Ee55oFiWAnQh6IE4ENUXZyASThQ4KkgACQr/hPbBM7SXnw== X-Google-Smtp-Source: AGHT+IEOoq8FzMijO6fXOts2TYrhs1sIAHiMI7KrMU4ZoGbVAoR2HWL/vL3WJmBkHBkS6522OQR4CQkETFimPKiwqvg= X-Received: by 2002:a05:6871:552:b0:3e7:e20a:39fb with SMTP id 586e51a60fabf-3e868eb8a15mr6637101fac.11.1763425127719; Mon, 17 Nov 2025 16:18:47 -0800 (PST) MIME-Version: 1.0 References: <97810758-0f5f-4e41-8e25-ac9dcd7a255e@aklaver.com> In-Reply-To: <97810758-0f5f-4e41-8e25-ac9dcd7a255e@aklaver.com> From: Ron Johnson Date: Mon, 17 Nov 2025 19:18:36 -0500 X-Gm-Features: AWmQ_bkXrKC16quHMVuZm8bDV9tycFoGdW23I4YM-t3dErjpR-Akc_4LUyclp8g Message-ID: Subject: Re: postgres in swap space To: "pgsql-general@lists.postgresql.org" Content-Type: multipart/alternative; boundary="0000000000005366f90643d368ea" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000005366f90643d368ea Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Mon, Nov 17, 2025 at 4:41=E2=80=AFPM Adrian Klaver wrote: > On 11/17/25 13:12, Ron Johnson wrote: > > On Mon, Nov 17, 2025 at 3:50=E2=80=AFPM Laurenz Albe > > wrote: > > > > On Mon, 2025-11-17 at 18:25 +0100, Marc Millas wrote: > > > Can someone point me to any doc describing why and how much spac= e > > 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) > > > > I'm biting down a comment. > > > > > > "If it ain't broke, don't fix it" works just fine (until it doesn't). > > The problem is when it doesn't work anymore, the work load to move to a > newer version is that much greater. That's my point. If it just *kept* working, there would be no problem. > Keeping the version within spitting > distance of the latest supported version, to me, is a good idea. > As much as people love to complain about how useless PCI DSS is (see the recent thread on TDE), there's one benefit: ensuring that companies keep computers patched and running supported software. --=20 Death to , and butter sauce. Don't boil me, I'm still alive. lobster! --0000000000005366f90643d368ea Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
On Mon, Nov 17, 2025 at 4:41=E2=80=AFPM A= drian Klaver <adrian.klaver= @aklaver.com> wrote:
On 11/17/25 13:12,= Ron Johnson wrote:
> On Mon, Nov 17, 2025 at 3:50=E2=80=AFPM Laurenz Albe <laurenz.albe@cybertec.at
> <mailto:
laurenz.albe@cybertec.at>> wrote:
>
>=C2=A0 =C2=A0 =C2=A0On Mon, 2025-11-17 at 18:25 +0100, Marc Millas wrot= e:
>=C2=A0 =C2=A0 =C2=A0 > Can someone point me to any doc describing wh= y and how much=C2=A0space
>=C2=A0 =C2=A0 =C2=A0postgres uses on the swap of a debian machine ?
>=C2=A0 =C2=A0 =C2=A0 > it's an old postgres 10, because it is us= ed by a product for
>=C2=A0 =C2=A0 =C2=A0which only this version is certified.
>=C2=A0 =C2=A0 =C2=A0 > (no comment on that, please)
>
>=C2=A0 =C2=A0 =C2=A0I'm biting down a comment.
>
>
> "If it ain't broke, don't fix it" works just fine (u= ntil it doesn't).

The problem is when it doesn't work anymore, the work load to move to a=
newer version is that much greater.

That= 9;s my point.=C2=A0 If it just kept working, there would be no probl= em.
=C2=A0
Keeping the version within spitting
distance of the latest supported version, to me, is a good idea.

As much as people love to complain about how usel= ess PCI DSS is (see the=C2=A0recent thread on TDE), there's one benefit= :=C2=A0ensuring that companies keep computers patched and running supported= software.

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