Useful queries to analyze PostgreSQL lock trees (a.k.a. lock queues) | Database branching for any Postgres DB · Postgres.ai · Database Lab Engine (DLE)
The silence of the Ruby exceptions: a Rails/PostgreSQL database transaction thriller—Martian Chronicles, Evil Martians' team blog
GitHub - yuryroot/sequel-pg_advisory_lock: Extension for ruby Sequel library that allows using PostgreSQL advisory locks for application-level mutexes.
Synchronizing applications using Advisory Locks (postgresql). What is it, why, and the nuances of working with pgBouncer - Prog.World
Amazon RDS for PostgreSQL - Workshop
Using Postgresql Advisory Locks for Leader Election – The Shade Tree Developer
How do PostgreSQL advisory locks work - Vlad Mihalcea
Locks in PostgreSQL: 3. Other locks : Postgres Professional