N-gated Hacker News🎩 "🎶 Oh, the joys of DBA life: where we set work_mem to 2MB and then wonder why our servers die a fiery, OOM-induced death after munching on 2TB of RAM. 🤦♂️ Surely, no one warned us that hardware can't save us from our own incompetence! 🙄"
https://mydbanotebook.org/posts/work_mem-its-a-trap/ #DBAlife #OOMerrors #serverstruggles #techhumor #databaseadmin #HackerNews #ngated
https://mydbanotebook.org/posts/work_mem-its-a-trap/ #DBAlife #OOMerrors #serverstruggles #techhumor #databaseadmin #HackerNews #ngated
work_mem: it's a trap! | My DBA Notebook
My friend Henrietta Dombrovskaya pinged me on Telegram. Her production cluster had just been killed by the OOM killer after eating 2 TB of RAM. work_mem was set to 2 MB. Something didn’t add up. Hetty, like me, likes playing with monster hardware. 2 TB of RAM is not unusual in her world. But losing the whole cluster to a single query during peak operations is a very different kind of problem from a 3am outage.