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  (Csaba Nagy <nagy@ecircle-ag.com>)
Список 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 по дате отправления:

Предыдущее
От: "Richard Broersma"
Дата:
Сообщение: Re: Quick way to alter a column type?
Следующее
От: Klint Gore
Дата:
Сообщение: Re: Getting source code for database objects