Everything You Need to Know About PostgreSQL Locks - postgreshelp
Richard Clayton - Distributed Locking with Postgres Advisory Locks
database - Optimistic vs. Pessimistic locking - Stack Overflow
POSTGRESQL LOCKING. Postgresql provides 3 different types… | by Mustafa Atik | Medium
What is ACCESS EXCLUSIVE LOCK Mode in PostgreySQL? - GeeksforGeeks
How do PostgreSQL advisory locks work - Vlad Mihalcea
postgresql - Debugging a hanging session/lock - Database Administrators Stack Exchange
How TimescaleDB Solves Common PostgreSQL Problems in Database Operations With Data Retention Management
How does the 2PL (Two-Phase Locking) algorithm work - Vlad Mihalcea
Relational Database Technologies: Deadlocks in PostgreSQL
The Internals of PostgreSQL : Chapter 2 Process and Memory Architecture
SELECT FOR UPDATE and its behavior with foreign keys in PostgreSQL - MigOps
PostgreSQL Locks
Global Deadlock and Detection in Local PostgreSQL Database
Locks in PostgreSQL: 4. Locks in memory : Postgres Professional
Handling Pessimistic Locking with JPA on Oracle, MySQL, PostgreSQL, Apache Derby and H2 | mimacom
Locks in PostgreSQL: 4. Locks in memory / Habr
database - Postgres select query with exclusice lock performance issue - Stack Overflow
PostgreSQL lock trees - DEV Community
Avoid PostgreSQL LWLock:buffer_content locks in Amazon Aurora: Tips and best practices | AWS Database Blog
Everything You Need to Know About PostgreSQL Locks - postgreshelp
Hussein Nasser on LinkedIn: Postgres locks are interesting and can be confusing to understand. There…
Handling Pessimistic Locking with JPA on Oracle, MySQL, PostgreSQL, Apache Derby and H2 | mimacom
The Internals of PostgreSQL : Chapter 5 Concurrency Control
Useful queries to analyze PostgreSQL lock trees (a.k.a. lock queues) | Database branching for any Postgres DB · Postgres.ai · DBLab
