I guess the clever lock semantics are SKIP LOCKED, which is designed to support ...

		fanf2 on Dec 18, 2021 \| parent \| context \| favorite \| on: Postgres is a great pub/sub and job server (2019) I guess the clever lock semantics are SKIP LOCKED, which is designed to support efficient queues. The cleverness is inside PostgreSQL rather than in the application, other than the cleverness of knowing about this feature. https://www.2ndquadrant.com/en/blog/what-is-select-skip-lock...

Yup, exactly that