Re: SKIP LOCKED DATA

Поиск
Список
Период
Сортировка
От Ilya Kosmodemiansky
Тема Re: SKIP LOCKED DATA
Дата
Msg-id CABvo6pRngLKwgP5oBjAcj94+BDFb0+3nZa9cYetScW8fqMkLgA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: SKIP LOCKED DATA  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: SKIP LOCKED DATA  (Thomas Munro <munro@ip9.org>)
Список 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 по дате отправления:

Предыдущее
От: Greg Smith
Дата:
Сообщение: Checkpoint sync pause
Следующее
От: Heikki Linnakangas
Дата:
Сообщение: Re: Group commit, revised