Comments on: How to Adjust Linux Out-Of-Memory Killer Settings for PostgreSQL https://www.percona.com/blog/out-of-memory-killer-or-savior/ Thu, 14 Dec 2023 00:58:20 +0000 hourly 1 https://wordpress.org/?v=6.5.2 By: Bruno Lavoie https://www.percona.com/blog/out-of-memory-killer-or-savior/#comment-10971078 Mon, 05 Aug 2019 13:16:27 +0000 https://www.percona.com/blog/?p=59394#comment-10971078 My error.. it disables handling of by always committing to memory requests… this docs should also add the “always” keyword ☺

]]> By: Ibrar Ahmed https://www.percona.com/blog/out-of-memory-killer-or-savior/#comment-10971077 Mon, 05 Aug 2019 13:16:08 +0000 https://www.percona.com/blog/?p=59394#comment-10971077 No, check the kernel documentation.

1 – Always overcommit. Appropriate for some scientific
applications. Classic example is code using sparse arrays
and just relying on the virtual memory consisting almost
entirely of zero pages.

https://www.kernel.org/doc/Documentation/vm/overcommit-accounting

]]> By: Bruno Lavoie https://www.percona.com/blog/out-of-memory-killer-or-savior/#comment-10971076 Mon, 05 Aug 2019 12:58:17 +0000 https://www.percona.com/blog/?p=59394#comment-10971076 Overcommit setting 1 disables it

https://access.redhat.com/documentation/en-us/red_hat_enterprise_linux/7/html/performance_tuning_guide/sect-red_hat_enterprise_linux-performance_tuning_guide-configuration_tools-configuring_system_memory_capacity

]]> By: Francesco https://www.percona.com/blog/out-of-memory-killer-or-savior/#comment-10971069 Fri, 02 Aug 2019 17:12:24 +0000 https://www.percona.com/blog/?p=59394#comment-10971069 When PS 8.0.16? Upstream is already at .17… That would fix the memory bug… 🙂

]]>