public inbox for [email protected]
help / color / mirror / Atom feedFrom: Jorge Rodriguez <[email protected]>
To: Bruce Momjian <[email protected]>
To: Frits Hoogland <[email protected]>
Cc: Joe Conway <[email protected]>
Cc: Priya V <[email protected]>
Cc: [email protected] <[email protected]>
Subject: Re: Safe vm.overcommit_ratio for Large Multi-Instance PostgreSQL Fleet
Date: Fri, 15 Aug 2025 15:14:32 +0000
Message-ID: <MW4PR05MB8748B984CEC4A9F1098C91848534A@MW4PR05MB8748.namprd05.prod.outlook.com> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>
<[email protected]>
<[email protected]>
available
Get Outlook for iOS<https://aka.ms/o0ukef;
________________________________
From: Bruce Momjian <[email protected]>
Sent: Tuesday, August 12, 2025 1:49:26 PM
To: Frits Hoogland <[email protected]>
Cc: Joe Conway <[email protected]>; Priya V <[email protected]>; [email protected] <[email protected]>
Subject: Re: Safe vm.overcommit_ratio for Large Multi-Instance PostgreSQL Fleet
Note: This message originated from outside the FIU Faculty/Staff email system.
On Wed, Aug 6, 2025 at 11:14:34PM +0200, Frits Hoogland wrote:
> > As I said, do not disable swap. You don't need a huge amount, but maybe 16 GB or so would do it.
>
> Joe, please, can you state a technical reason for saying this?
> All you are saying is ‘don’t do this’.
>
> I’ve stated my reasons for why this doesn’t make sense, and you don’t give any reason.
>
> The article you cite does seem to point to general usage, not database usage.
Here is a blog entry about it from 2012:
https://urldefense.com/v3/__https://momjian.us/main/blogs/pgblog/2012.html*July_25_2012__;Iw!!FjuHKA...
--
Bruce Momjian <[email protected]> https://urldefense.com/v3/__https://momjian.us__;!!FjuHKAHQs5udqho!KYC_U3_OpOjplPgrQZatREvJ8Ft3U7O30...
EDB https://urldefense.com/v3/__https://enterprisedb.com__;!!FjuHKAHQs5udqho!KYC_U3_OpOjplPgrQZatREvJ8Ft...
Do not let urgent matters crowd out time for investment in the future.
view thread (13+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected], [email protected], [email protected], [email protected]
Subject: Re: Safe vm.overcommit_ratio for Large Multi-Instance PostgreSQL Fleet
In-Reply-To: <MW4PR05MB8748B984CEC4A9F1098C91848534A@MW4PR05MB8748.namprd05.prod.outlook.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox