News for hackers. Stuff that matters.
Re:ClickHouse matches PG for single-row UPDATEs and 4000 x f... by immibis on Sunday August 17, 2025 @07:30PM (#44935855)
Oddly enough, for a big enough update, postgres sometimes will do the math and decide that scanning the whole table is faster than scanning the index and then scanning a certain fraction of the table (considering also that it has to rewrite the entire page if any row in the page is updated)

There are no comments on this comment yet.