5 PostgreSQL locking behaviors that trip people up
Summary
The article explains five counterintuitive PostgreSQL locking behaviors under MVCC, with concrete session scenarios, impact, and mitigations. It's a solid resource for DBAs and SMB IT teams to prevent outages caused by lock contention.