A blog and newsletter on ClickHouse internals, schema design, and query optimization at scale.

Follow

  1. Query OptimizationReading ClickHouse EXPLAIN Plans for Query TuningLearn which EXPLAIN variant reveals performance bottlenecks at each query phase.Marcus Hjelm · 10 min read
  2. Schema Design for OLAPModeling Time-Series Data in ClickHouse MergeTreeClickHouse's MergeTree engine demands careful ORDER BY and type choices to query efficiently.Adaeze Okonkwo · 9 min read
  3. ClickHouse OperationsClickHouse Cluster Sharding and Distributed Table DesignScale vertically first, then shard only when data or query load demands it.Priya Venkatasubramanian · 10 min read