Jeremy Evans d1f8e9b332 Use FOR NO KEY UPDATE instead of FOR UPDATE ...

FOR UPDATE takes stronger locks, and is only needed if you plan on
deleting the row or modifying one of key columns.  If you use FOR
UPDATE, you block other transactions insert rows that reference a
row using a FOR UPDATE lock.  From looking at these cases, I don't
think that is the case, so using FOR NO KEY UPDATE should allow
the assurances we need without unnecessarily blocking other
concurrent transactions.

2025-07-04 09:26:06 +09:00

7.9 KiB

Raw Permalink Blame History

View Raw