Postgres advisory locks

Postgres offers two types of locks; database locks (such as table or row) and advisory locks. An advisory lock is a lock that is acquired by a client on a specific resource that is not automatically enforced by the database server, but instead is use...