Hacker News new | ask | show | jobs
by advisedwang 3136 days ago
Reason (1) is very likely. User code can send UPDATEs within a transaction in any order. While processing an early UPDATE, you can't know what later UPDATEs are coming, so can't get those locks.