Re: Feature: FOR UPDATE SKIP LOCKED

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Jonathan Bond-Caron" <jbondc(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Feature: FOR UPDATE SKIP LOCKED
Date: 2008-07-09 04:48:34
Message-ID: 4157.1215578914@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Jonathan Bond-Caron" <jbondc(at)gmail(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Pavel Stehule 2008-07-09 05:28:22 Re: array sort for varchar arrays?
Previous Message Richard Broersma 2008-07-09 04:42:58 Re: Quick way to alter a column type?