Steven Winfield wrote: > Just to be clear, are you suggesting (on linux) setting overcommit_memory = 2 > but leaving overcommit_ratio alone, which defaults to 50%? > I’ve tried setting them to 2 and 0% respectively in the past and it didn’t > end well…
Yes, vm.overcommit_memory = 2 As for vm.overcommit ratio, set it to 100 * (RAM - swap) / RAM That is because Linux will commit memory up to swap + overcommit_ratio * RAM / 100, and you don't want to commit more than the available RAM. > Also I’ve read, and now use, swappiness = 1 which is supposed to disable > swapping > entirely except when not swapping would cause OOM. > Any thoughts on that? My thought is vm.swappiness = 0 If you don't overcommit memory, you should never have to swap. Yours, Laurenz Albe -- Cybertec | https://www.cybertec-postgresql.com
