Re: Safe vm.overcommit_ratio for Large Multi-Instance PostgreSQL Fleet - Mailing list pgsql-performance

From Frédéric Yhuel
Subject Re: Safe vm.overcommit_ratio for Large Multi-Instance PostgreSQL Fleet
Date
Msg-id 98eb084c-457d-4638-8f1f-d14f9eb2a634@dalibo.com
Whole thread Raw
In response to Re: Safe vm.overcommit_ratio for Large Multi-Instance PostgreSQL Fleet  (Frits Hoogland <frits.hoogland@gmail.com>)
List pgsql-performance

On 8/19/25 17:37, Frits Hoogland wrote:
> The specific issue I see in certain cases leading to unreasonable swap usage is Linux workingset detection kicking
in

Do you have a way to highlight that precisely? I mean, can you prove 
that it is Linux workingset detection that is causing swapping? I've 
also encountered surprising cases where the swap fills up despite there 
being plenty of available memory (lots of page cache). However these 
cases were not associated with slowdowns or other problems. I only 
became aware of them because a client was anxious about her swap usage.



pgsql-performance by date:

Previous
From: Frits Hoogland
Date:
Subject: Re: Safe vm.overcommit_ratio for Large Multi-Instance PostgreSQL Fleet