Search Postgresql Archives

RE: Advice on machine specs for growth

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



> Disable memory overcommit and set swappiness to 0 on database servers.

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…

 

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?

 

Cheers,

Steve.

 


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux