Row Locking

Claim Queue Rows with FOR UPDATE SKIP LOCKED in PostgreSQL Several workers poll the same job table with SELECT ... LIMIT 10, and a plain LIMIT does nothing to stop two of them from getting the same list of items to process. Add FOR UPDATE and the second worker hangs until the first one commits. Put FOR UPDATE SKIP …