medium10 pts · first answer countslockingpostgresql

Workers fighting over jobs

Ten workers pick jobs with SELECT ... WHERE status = 'pending' LIMIT 1 FOR UPDATE, and they mostly wait on each other. Which change lets them grab different jobs in parallel?

A.Add FOR UPDATE SKIP LOCKED so each worker skips rows already locked by othersB.Use SERIALIZABLE isolationC.Remove FOR UPDATE completelyD.Add NOWAIT and retry in a tight loop

← Session state behind pgBouncer MySQL default isolation level →