On Sat, Feb 23, 2019 at 4:06 PM Gunther <r...@gusw.net> wrote: > the dequeue operation is essentially this: > > BEGIN > > SELECT jobId, action > FROM Queue > WHERE pending > FOR UPDATE SKIP LOCKED > > There is no LIMIT shown. Wouldn't the first thread to start up just lock all the rows and everyone else would starve?
Cheers, Jeff