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)
[ Parent
| on HN ]
There are no comments on this comment yet.