What is SKIP LOCKED for in PostgreSQL? Most work queue implementations are wro | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

		What is SKIP LOCKED for in PostgreSQL? Most work queue implementations are wro (2ndquadrant.com)
		11 points by todsacerdoti on Dec 30, 2021 \| hide \| past \| favorite \| 1 comment

mrhands556 on Dec 30, 2021 [–]

I’ve used to this for distributed locking on jobs and it’s been great. The other janky implementation (without some distributed locks or task manager) would be incrementAndGet with a TTL. Obviously this runs into a lot more edge cases.

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact