On Sat, Feb 23, 2019 at 4:06 PM Gunther <raj(at)gusw(dot)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