Locking on rows or values that don't exist in PostgreSQL – Ross Coded Classes
Locks in PostgreSQL: 4. Locks in memory : Postgres Professional
Understanding Deadlocks in MySQL & PostgreSQL | Severalnines
Everything You Need to Know About PostgreSQL Locks - postgreshelp
PostgreSQL Lock Table | How to Lock Table in PostgreSQL? | Examples
Useful queries to analyze PostgreSQL lock trees (a.k.a. lock queues) | Database branching for any Postgres DB · Postgres.ai · Database Lab Engine (DLE)
concurrency - How to simulate deadlock in PostgreSQL? - Stack Overflow