Postgres row locks in practice

For years I used SELECT ... FOR UPDATE without really thinking about it. This week I actually read...