Advisory Locks for Application Logic

Use database-level advisory primitives to coordinate external tasks outside the data model.