Tom Lane wrote: > Frankly, I'm entirely unpersuaded. It will do zilch to improve the OOM > problem, and I cannot see any way of restricting global memory > consumption that won't hurt performance and flexibility.
Yeah, the only way to improve the OOM problem would be to harass the Linux developers to tweak badness() so that it considers the postmaster to be an essential process rather than the one to preferentially kill. As you said, perhaps the way to improve the current situation is to get packagers to tweak /proc/xyz/oom_adj on the initscript. -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
