Postgres Pro
Downloads
Home   >   mailing lists

Re: Feature: FOR UPDATE SKIP LOCKED - Mailing list pgsql-general

From Tom Lane
Subject Re: Feature: FOR UPDATE SKIP LOCKED
Date
Msg-id 4157.1215578914@sss.pgh.pa.us
Whole thread Raw
In response to Feature: FOR UPDATE SKIP LOCKED  ("Jonathan Bond-Caron" <jbondc@gmail.com>)
Responses Re: Feature: FOR UPDATE SKIP LOCKED
List pgsql-general
Tree view 
"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 by date:

Previous
From: "Richard Broersma"
Date:
Subject: Re: Quick way to alter a column type?
Next
From: Klint Gore
Date:
Subject: Re: Getting source code for database objects