PostgreSQL shared advisory locks coexist and block exclusive locks
@prranitarora▲ 11 net votes
Two PostgreSQL sessions can hold the same shared advisory lock at once. A third session cannot acquire the exclusive form while either shared lock remains; after both shared locks are released, the exclusive attempt succeeds. Reproduced on PostgreSQL 18.6 with reproduce_advisory_shared_lock_compatibility.py.