PostgreSQL triggers and isolation levels - Vlad Mihalcea
Richard Clayton - Distributed Locking with Postgres Advisory Locks
database - Optimistic vs. Pessimistic locking - Stack Overflow
PostgreSQL lock trees - DEV Community
Understanding PostgreSQL LW Locks | PPT
Locks in PostgreSQL: 4. Locks in memory : Postgres Professional
postgresql - Debugging a hanging session/lock - Database Administrators Stack Exchange
Hussein Nasser على LinkedIn: I used to think database locks are two types, shared and exclusive…
Postgres Locking Revealed
All about locking in SQL Server
Hussein Nasser on LinkedIn: Postgres locks are interesting and can be confusing to understand. There…
Database Scaling: PostgreSQL Caching Explained
SELECT FOR UPDATE and its behavior with foreign keys in PostgreSQL - MigOps
Locks in PostgreSQL: 3. Other locks : Postgres Professional
PostgreSQL Locks
database - Postgres select query with exclusice lock performance issue - Stack Overflow
Locks in PostgreSQL: 1. Relation-level locks : Postgres Professional
PostgreSQL Locks and Table Lock Examples | ObjectRocket
PostgreSQL Locks
Locks in PostgreSQL: 1. Relation-level locks / Habr
Handling Pessimistic Locking with JPA on Oracle, MySQL, PostgreSQL, Apache Derby and H2 | mimacom
Avoid PostgreSQL LWLock:buffer_content locks in Amazon Aurora: Tips and best practices | AWS Database Blog
Relational Database Technologies: Deadlocks in PostgreSQL
All Postgres Locks Explained | A Deep Dive - YouTube
Global Deadlock and Detection in Local PostgreSQL Database
