The ClickHouse Memory Win That Didn't Show Up On the Dashboard
A ClickHouse materialized view cutover at Frost dropped per-fire memory from 140 MiB to 7.4 MiB. The cluster's resident memory didn't move a byte. Here's the SQL pattern that made it work, and the more important lesson about which memory metric actually predicted our OOM exposure.
May 27, 2026 · 11 min read