Row Locks with Joins Can Produce Surprising Results in PostgreSQL (hakibenita.com)

Posts like these make me realize I know next to nothing about a lot of the systems I daily work with.

It is always humbling to read things like these!