Date: Tue, 12 Aug 2025 13:49:26 -0400
From: Bruce Momjian <bruce@momjian.us>
To: Frits Hoogland <frits.hoogland@gmail.com>
Cc: Joe Conway <mail@joeconway.com>, Priya V <mailme0216@gmail.com>,
	pgsql-performance@lists.postgresql.org
Subject: Re: Safe vm.overcommit_ratio for Large Multi-Instance PostgreSQL
 Fleet
Message-ID: <aJt-psTDjOt_vTVZ@momjian.us>
References: <f35cdf25-411f-4cbc-a877-85569cf78061@joeconway.com>
 <3A250F65-F5DE-4E24-ADE7-BEFF4A18A8B9@gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
In-Reply-To: <3A250F65-F5DE-4E24-ADE7-BEFF4A18A8B9@gmail.com>
Archived-At: 
 <https://www.postgresql.org/message-id/aJt-psTDjOt_vTVZ%40momjian.us>
Precedence: bulk

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://momjian.us/main/blogs/pgblog/2012.html#July_25_2012

-- 
  Bruce Momjian  <bruce@momjian.us>        https://momjian.us
  EDB                                      https://enterprisedb.com

  Do not let urgent matters crowd out time for investment in the future.