ClickHouse: Using Indexes, Projections, and Data Skipping for Speed
TL;DR ClickHouse doesn’t use B‑trees the way OLTP databases do. Its speed comes from: a sparse primary index on the ORDER BY key to jump to releva...
Recent posts
Introducing LiveKit Dashboard: Simplifying Self-Hosted Real-Time Management
Running LiveKit at scale is powerful — but it can also feel like you’re managing a live concert with the lights off. You’ve got rooms, participants, servers,...
Breaking Down Python 3.13’s Experimental Free‑Threading Mode
The year the GIL blinked. With Python 3.13, CPython gained an experimental “free‑threading” build that can run threads truly in parallel on multiple cores. I...
Parts, Not Pages: A Mental Model for How ClickHouse Stores Data
If you’ve used ClickHouse for more than ten minutes, you’ve probably seen mysterious words in system tables and error messages: parts, granules, marks, mutat...
Adding a Column in ClickHouse, Deeply: What Actually Happens and What to Consider
“It’s just one more column.” Famous last words.