Locks in PostgreSQL: 1. Relation-level locks / Habr
Handling Pessimistic Locking with JPA on Oracle, MySQL, PostgreSQL, Apache Derby and H2 | mimacom
How do PostgreSQL advisory locks work - Vlad Mihalcea
Useful queries to analyze PostgreSQL lock trees (a.k.a. lock queues) | Database branching for any Postgres DB · Postgres.ai · Database Lab Engine (DLE)
Handling Pessimistic Locking with JPA on Oracle, MySQL, PostgreSQL, Apache Derby and H2 | mimacom