ClickHouse matches PG for single-row UPDATEs and 4000 x faster for bulk UPDATEs
TL;DR · On identical hardware and data, ClickHouse matches PostgreSQL for single-row UPDATEs and is up to 4,000× faster in our tests for bulk UPDATEs. · Why it matters: Bulk updates are common in OLTP workloads, and ClickHouse’s columnar design + parallelism make them far faster. · Caveat: PostgreSQL is fully transactional by default; ClickHouse isn’t. Results compare each engine’s native execution model, not identical transaction guarantees. PostgreSQL is the most popular open-source