Record · corpus.blog/posts/01a07df2-4c8b-71c9-a1f7-d6d4660fda26

You can’t UPDATE what you can’t find: ClickHouse vs PostgreSQL

ClickHouse · published 13 August 2025

A record is what was published and who pointed at it. The text of the post is not held here: read it at the source, or at its Wayback capture.

Read the post at clickhouse.com Wayback capture

0blogs citing

First cited: —
Most recent: —
Rank this month: not ranked
Links from this post: 31
Words captured: 3,609

Cited by

No blog we hold has cited this post yet.

Links from this post

Link

Host

https://clickhouse.com/resources/engineering/oltp-vs-olap

clickhouse.com

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

clickhouse.com

How we made ClickHouse UPDATEs 1,000× faster (Part 3: Benchmarks) Read at the source ↗

clickhouse.com

https://en.wikipedia.org/wiki/Multiversion_concurrency_control

en.wikipedia.org

https://www.postgresql.org/docs/current/sql-vacuum.html

postgresql.org

https://clickhouse.com/docs/parts

clickhouse.com

ClickHouse Release 25.6 Read at the source ↗

clickhouse.com

https://clickhouse.com/docs/merges

clickhouse.com

https://www.postgresql.org/docs/current/tutorial-transactions.html

postgresql.org

https://www.postgresql.org/docs/current/wal-intro.html

postgresql.org

https://clickhouse.com/docs/guides/developer/transactional

clickhouse.com

https://clickhouse.com/docs/getting-started/example-datasets/tpch

clickhouse.com

https://www.tpc.org/TPC_Documents_Current_Versions/pdf/TPC-H_v3.0.1.pdf

tpc.org

https://www.postgresql.org/docs/current/indexes-types.html

postgresql.org

https://clickhouse.com/docs/primary-indexes

clickhouse.com

https://github.com/ClickHouse/examples/blob/ec031e87ec602da81fb844d81757ee9f1e912b57/blog-examples/UPDATEBench/postgresql/scripts/benchmark.sh

github.com

https://github.com/ClickHouse/examples/tree/main/blog-examples/UPDATEBench

github.com

https://github.com/ClickHouse/examples/blob/ec031e87ec602da81fb844d81757ee9f1e912b57/blog-examples/UPDATEBench/postgresql/scripts/updates-point.sql

github.com

https://github.com/ClickHouse/examples/blob/ec031e87ec602da81fb844d81757ee9f1e912b57/blog-examples/UPDATEBench/postgresql/results/cold_point.json

github.com

https://github.com/ClickHouse/examples/blob/ec031e87ec602da81fb844d81757ee9f1e912b57/blog-examples/UPDATEBench/clickhouse/results/update_timings_sequential_lightweight_p20_COLD_POINT.json

github.com

https://clickhouse.com/docs/guides/best-practices/sparse-primary-indexes

clickhouse.com

https://clickhouse.com/docs/optimize/query-parallelism

clickhouse.com

https://github.com/ClickHouse/examples/blob/ec031e87ec602da81fb844d81757ee9f1e912b57/blog-examples/UPDATEBench/postgresql/scripts/analytical_queries.sql

github.com

https://github.com/ClickHouse/examples/blob/ec031e87ec602da81fb844d81757ee9f1e912b57/blog-examples/UPDATEBench/postgresql/scripts/updates-bulk.sql

github.com

https://github.com/ClickHouse/examples/blob/ec031e87ec602da81fb844d81757ee9f1e912b57/blog-examples/UPDATEBench/postgresql/results/cold_bulk.json

github.com

https://github.com/ClickHouse/examples/blob/ec031e87ec602da81fb844d81757ee9f1e912b57/blog-examples/UPDATEBench/clickhouse/results/update_timings_sequential_lightweight_p20_COLD_BULK.json

github.com

https://clickhouse.com/docs/intro

clickhouse.com

https://github.com/ClickHouse/examples/blob/ec031e87ec602da81fb844d81757ee9f1e912b57/blog-examples/UPDATEBench/postgresql/results/hot_point.json

github.com

https://github.com/ClickHouse/examples/blob/main/blog-examples/UPDATEBench/clickhouse/results/update_timings_sequential_lightweight_p20_HOT_POINT.json

github.com

https://github.com/ClickHouse/examples/blob/ec031e87ec602da81fb844d81757ee9f1e912b57/blog-examples/UPDATEBench/postgresql/results/hot_bulk.json

github.com

https://github.com/ClickHouse/examples/blob/ec031e87ec602da81fb844d81757ee9f1e912b57/blog-examples/UPDATEBench/clickhouse/results/update_timings_sequential_lightweight_p20_HOT_BULK.json

github.com