Re: Feature: FOR UPDATE SKIP LOCKED

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Feature: FOR UPDATE SKIP LOCKED
Дата
Msg-id 4157.1215578914@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Feature: FOR UPDATE SKIP LOCKED  ("Jonathan Bond-Caron" <jbondc@gmail.com>)
Ответы Re: Feature: FOR UPDATE SKIP LOCKED
Список pgsql-general
"Jonathan Bond-Caron" <jbondc@gmail.com> writes:
> It would be quite useful to implement a database queue. Although FOR UPDATE
> NOWAIT and trying again can work as well as other techniques,

> just skipping over the locks has its advantages (simplicity and zero wait)

And disadvantages, such as complete lack of predictability or failure
detection.

            regards, tom lane

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