Advisory locks are application-defined locks (`pg_advisory_lock`) not tied to a specific table row. They help when you need “only one worker does this” coordination (e.g., one scheduled job). They’re not a substitute for DB constraints and you must handle timeouts and failures carefully.