| From: | Bruce Momjian <bruce(at)momjian(dot)us> |
|---|---|
| To: | Frits Hoogland <frits(dot)hoogland(at)gmail(dot)com> |
| Cc: | Joe Conway <mail(at)joeconway(dot)com>, Priya V <mailme0216(at)gmail(dot)com>, pgsql-performance(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Safe vm.overcommit_ratio for Large Multi-Instance PostgreSQL Fleet |
| Date: | 2025-08-12 17:49:26 |
| Message-ID: | aJt-psTDjOt_vTVZ@momjian.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
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(at)momjian(dot)us> https://momjian.us
EDB https://enterprisedb.com
Do not let urgent matters crowd out time for investment in the future.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Pavel Stehule | 2025-08-13 19:24:09 | Re: proposal: schema variables |
| Previous Message | Frits Hoogland | 2025-08-08 08:21:40 | Re: Safe vm.overcommit_ratio for Large Multi-Instance PostgreSQL Fleet |