Notes on lockingIn addition to the locks already described, foreign key lookups
require briefly held shared locks on the referenced table (row or table, depending
on the configuration).
The table and examples in this section do not take performance-based lock
escalation into account. Remember that the system can choose table-level locking
for performance reasons.