Advisory lock grant order

Поиск
Список
Период
Сортировка
От Yossi Cohen
Тема Advisory lock grant order
Дата
Msg-id CAEfuueTFjh6Mn-yiARREcDjWskXvoA6eEGhw=wKFGHN5F=Bx1g@mail.gmail.com
обсуждение исходный текст
Ответы Re: Advisory lock grant order  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Hi,

If I request an advisory lock (pg_advisory_lock) with the same key from several sessions; will the lock be granted in the same order as it was requested?
I.e. if for example:

session 1: select pg_advisory_lock(1); -- acquires the lock
then
session 2: select pg_advisory_lock(1); -- blocks waiting for the lock
then
session 3: select pg_advisory_lock(1); -- blocks waiting for the lock

then
session 1: select pg_advisory_unlock(1); -- releases the lock

Is it guaranteed that now session 2 will be granted the lock because it requested the lock before session 3?

Thanks,
Yossi

В списке pgsql-general по дате отправления:

Предыдущее
От: Michael Paquier
Дата:
Сообщение: Re: Crash in 9.4 Beta when partially collapsing left outer joins
Следующее
От: Dmitriy Igrishin
Дата:
Сообщение: Re: Async IO HTTP server frontend for PostgreSQL