# How we made ClickHouse UPDATEs 1,000x faster (Part 3: Benchmarks)

DevFeed: [How we made ClickHouse UPDATEs 1,000x faster (Part 3: Benchmarks)](<https://devfeed.tech/articles/how-we-made-clickhouse-updates-1-000-faster-part-3-benchmarks-5621.md>)

Original publisher: [Read original article](<https://clickhouse.com/blog/updates-in-clickhouse-3-benchmarks>)

Author: Tom Schreiber

Published: 2025-08-07T00:00:00Z

Content type: article

Language: en

Sources: [ClickHouse Blog](<https://devfeed.tech/sources/clickhouse-blog.md>)

Topics: [clickhouse](<https://devfeed.tech/topics/clickhouse.md>), [Benchmark](<https://devfeed.tech/topics/benchmark.md>), [SQL](<https://devfeed.tech/topics/sql.md>), [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [dataset](<https://devfeed.tech/topics/dataset.md>), [Latency](<https://devfeed.tech/topics/latency.md>)

Tags: [benchmarks](<https://devfeed.tech/tags/benchmarks.md>), [clickhouse](<https://devfeed.tech/tags/clickhouse.md>), [data](<https://devfeed.tech/tags/data.md>), [latency](<https://devfeed.tech/tags/latency.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [sql](<https://devfeed.tech/tags/sql.md>)

## AI overview

This benchmark article examines standard SQL UPDATEs in ClickHouse using lightweight patch-part updates. It reports up to 1,000x speedups over classic mutations, including a bulk update completed in 60 ms instead of 100 seconds, and compares ClickHouse with PostgreSQL on identical hardware and data.

## Source excerpt

ClickHouse now supports standard SQL UPDATEs using lightweight patch-part updates, up to 1,000x faster than classic mutations in our tests, with minimal worst-case query overhead.