# You can't UPDATE what you can't find: ClickHouse vs PostgreSQL

DevFeed: [You can't UPDATE what you can't find: ClickHouse vs PostgreSQL](<https://devfeed.tech/articles/you-can-t-update-what-you-can-t-find-clickhouse-vs-postgresql-5616.md>)

Original publisher: [Read original article](<https://clickhouse.com/blog/update-performance-clickhouse-vs-postgresql>)

Author: Al Brown; Tom Schreiber

Published: 2025-08-13T05:55:15Z

Content type: comparison

Language: en

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

Topics: [Database](<https://devfeed.tech/topics/database.md>)

Tags: [benchmarks](<https://devfeed.tech/tags/benchmarks.md>), [cache](<https://devfeed.tech/tags/cache.md>), [clickhouse](<https://devfeed.tech/tags/clickhouse.md>), [data](<https://devfeed.tech/tags/data.md>), [database](<https://devfeed.tech/tags/database.md>), [hardware](<https://devfeed.tech/tags/hardware.md>), [performance](<https://devfeed.tech/tags/performance.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [speed](<https://devfeed.tech/tags/speed.md>), [sql](<https://devfeed.tech/tags/sql.md>), [update](<https://devfeed.tech/tags/update.md>)

## AI overview

This article compares ClickHouse and PostgreSQL UPDATE performance on identical hardware and data, covering cold and cached runs for single-row and bulk updates while noting their different transaction and durability models.

## Source excerpt

See how ClickHouse's update speed stacks up against PostgreSQL on the same data and hardware.