3 ms·
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
by advisedwang 9y 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.