Re: Massive parallel queue table causes index deterioration, but REINDEX fails with deadlocks.

[Jeff Janes <jeff.janes@xxxxxxxxx>]

On Sat, Feb 23, 2019 at 4:06 PM Gunther <raj@xxxxxxxx> 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