PostgreSQL and the OOM Killer: Why We Use Strict Memory Overcommit(ubicloud.com)

PostgreSQL and the OOM Killer: Why We Use Strict Memory Overcommit

https://www.ubicloud.com/blog/postgresql-and-the-oom-killer-why-we-use-strict-memory-overcommit

3 comments

pwmtrmese scorso

The author of the blog post here.

In hindsight, the kernel bug seems obvious, but the process of tracking it down was quite interesting. I especially enjoyed the statistical analysis part, which isn't something you normally get to do while debugging :)

Anyway, I'd be happy to answer any questions you might have.

__smese scorso

"it's always something stupid" has been my approach to bugs for a long time. hindsight 20/20

__smese scorso

we recently ran into trouble where PGroonga on the other hand needs overcommit enabled, in direct opposition to postgres preferences: https://pgroonga.github.io/how-to/tuning.html