How we built fast UPDATEs for the ClickHouse column store – Part 1: Purpose-built engines

T1Covered by 1 source · first reported by Databricks / ClickHouse / DuckDB / Supabase / Neon / PlanetScale at 22 Jul 2025, 00:00 UTC

ClickHouse is a column store, but that doesn’t mean updates are slow. In this post, we explore how purpose-built engines like ReplacingMergeTree deliver fast, efficient UPDATE-like behavior through smart insert semantics.

Sources

• T1How we built fast UPDATEs for the ClickHouse column store – Part 1: Purpose-built enginesDatabricks / ClickHouse / DuckDB / Supabase / Neon / PlanetScale22 Jul 2025, 00:00