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

Поиск
Список
Период
Сортировка
От Jeff Janes
Тема Re: Massive parallel queue table causes index deterioration, but REINDEX fails with deadlocks.
Дата
Msg-id CAMkU=1x4Pxe3vD5NhSisRgOVbF=8MBA9JA2CU-Lgcuit6uQhNg@mail.gmail.com
обсуждение исходный текст
Ответ на Massive parallel queue table causes index deterioration, but REINDEX fails with deadlocks.  (Gunther <raj@gusw.net>)
Список pgsql-performance
Дерево обсуждения
On Sat, Feb 23, 2019 at 4:06 PM Gunther <raj@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
Вложения

В списке pgsql-performance по дате отправления: