News for hackers. Stuff that matters.
Re:ClickHouse matches PG for single-row UPDATEs and 4000 x f... by compumike on Sunday August 17, 2025 @03:59PM (#44934444)
PostgreSQL defaults to: "fsync = ON" and "synchronous_commit = ON".

ClickHouse defaults to: "fsync_after_insert = false".

A more fair comparison might at least do "SET synchronous_commit TO OFF" on the PostgreSQL side. (But for this UPDATE benchmark, I think the results would still largely be the same.)

There are no comments on this comment yet.