Feature: FOR UPDATE SKIP LOCKED

From: "Goldeneye Solutions Information" <info(at)gdesolutions(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Feature: FOR UPDATE SKIP LOCKED
Date: 2008-07-09 00:49:49
Message-ID: 001201c8e15d$b115e770$1341b650$@com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I'm been reading up on FOR UPDATE NOWAIT and it looks like It was added in
8.1.

How difficult is it to add FOR UPDATE SKIP LOCKED or something similar?
(basically skip locked rows / oracle syntax)

More background here:

http://forge.mysql.com/worklog/task.php?id=3597

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)

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ow Mun Heng 2008-07-09 03:09:49 Re: Quick way to alter a column type?
Previous Message dgront 2008-07-08 22:12:11 Complicated GROUP BY