Re: SKIP LOCKED DATA - Mailing list pgsql-hackers

From Ilya Kosmodemiansky
Subject Re: SKIP LOCKED DATA
Date
Msg-id CABvo6pRngLKwgP5oBjAcj94+BDFb0+3nZa9cYetScW8fqMkLgA@mail.gmail.com
Whole thread Raw
In response to Re: SKIP LOCKED DATA  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: SKIP LOCKED DATA
List pgsql-hackers
That is quite useful feature to implement smth. like message queues
based on database and so on.
Now there is possibility to jump over luck of such feature in Postgres
using current advisory lock implementation (pg_try_advisory_xact_lock
to determine if somebody already acquired log on particular row).
So Im not sure this is an urgent matter.

Best regards,
Ilya

On Mon, Jan 16, 2012 at 6:33 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> It sounds to me like "silently give the wrong answers".  Are you sure
> there are not better, more deterministic ways to solve your problem?
>
> (Or in other words: the fact that Oracle has it isn't enough to persuade
> me it's a good idea.)
>
>                        regards, tom lane
>
> --
> Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-hackers


pgsql-hackers by date:

Previous
From: Greg Smith
Date:
Subject: Checkpoint sync pause
Next
From: Heikki Linnakangas
Date:
Subject: Re: Group commit, revised