Observed arrival · 2026-09-28
Think in Columns makes ClickHouse storage visual
A visual guide explains how ClickHouse uses columns, partitions, and indexes to limit the data a query reads.
○Open
⊠Login
$Paid
†Ads
✦Pretty
●Pro
◎Niche
◉Human
⚑Risk
ƒJS
- For
- People learning to use ClickHouse efficiently
- Worth noticing
- Its 10 TiB-to-0.9 MiB example is explicitly illustrative; sizes and ratios are typical, not measured, and the diagram is not to scale.
Field notes
The guide contrasts row and column layouts, then walks through how selecting only some columns can avoid reading wider payload fields. A separate example combines partitions, indexes, and columns to show a much smaller read; its figures are labeled illustrative, and the diagram is not to scale.
Observed signals
Read the marks
Editorial observations of this landing page, not a rating.
○OpenPublic substance visible
✦PrettyNotable craft visible
◎NicheUnusually specific use
One card from the complete issue