Every few years someone discovers FOR UPDATE SKIP LOCKED and represents it. I remember it lasting for 15 years at least
The "someone" in this case happens to be Michael Stonebraker, the creator of Postgres and CTO of DBOS.
So glad someone else chuckled reading this. Two thumbs up for knowing better than the creator of the thing they're talking about!
Yup, some features are timeless and deserve a re-intro every now and then. SKIP LOCKED is definitely one of them.
with a nice NOWAIT when appropriate
The "someone" in this case happens to be Michael Stonebraker, the creator of Postgres and CTO of DBOS.
So glad someone else chuckled reading this. Two thumbs up for knowing better than the creator of the thing they're talking about!
Yup, some features are timeless and deserve a re-intro every now and then. SKIP LOCKED is definitely one of them.
with a nice NOWAIT when appropriate