advisory lock term
application-level lock the DB tracks but doesn't enforce
Postgres pg_advisory_lock. You decide what it protects. Useful as a simple cluster-wide mutex piggybacking on the DB. Survives until session ends. Cheap, no schema needed.
application-level lock the DB tracks but doesn't enforce
Postgres pg_advisory_lock. You decide what it protects. Useful as a simple cluster-wide mutex piggybacking on the DB. Survives until session ends. Cheap, no schema needed.