Get the latest tech news
ClickHouse matches PG for single-row UPDATEs and 4000 x faster for bulk UPDATEs
See how ClickHouse’s update speed stacks up against PostgreSQL on the same data and hardware.
These queries represent the kind of real-time dashboards and analytical reports where users expect updated facts to be reflected immediately after a change. Handling special-case bulk actions – marking orders as “priority,” “warranty extended,” or “return-flagged” based on filters like commit date or quantity. As before, unsurprisingly, ClickHouse is consistently much faster than PostgreSQL on the same hardware and same dataset for typical analytical queries that would immediately benefit from updated data.
Or read this on Hacker News
