How we built fast UPDATEs for the ClickHouse column store – Part 2: SQL-style UPDATEs

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

ClickHouse can do fast, declarative UPDATEs. Patch parts make it possible, with minimal I/O, instant query visibility, and high parallelism. This post breaks down the mechanics that make it all work.

Sources

• T1How we built fast UPDATEs for the ClickHouse column store – Part 2: SQL-style UPDATEsDatabricks / ClickHouse / DuckDB / Supabase / Neon / PlanetScale24 Jul 2025, 00:00