On Tue, 2020-05-05 at 10:11 +0200, Marc Rechté wrote: > > I think that "vm.swappiness" should be 0. > > PostgreSQL does its own memory management, any swapping by the kernel > > would go against that. > > > > Yours, > > Laurenz Albe > > > As said in the post, we wish the idle backends to be swapped out if > necessary. Therefore lowering swappiness would produce the opposite > effect: swapping out Linux file cache rather than backends memory.
I see. Sorry for not paying attention. An idle backend consumes only a few MB of RAM, though. Yours, Laurenz Albe -- Cybertec | https://www.cybertec-postgresql.com
