Re: Are advisory locks guaranteed to be First Come First Serve? And can the behavior be relied upon?

Поиск
Список
Период
Сортировка
От Hemil Ruparel
Тема Re: Are advisory locks guaranteed to be First Come First Serve? And can the behavior be relied upon?
Дата
Msg-id CANW1aT-Eu58R4Cty=i=nV1Hy=of4VL+gY_q4FgFLBYwnmKtH4w@mail.gmail.com
обсуждение исходный текст
Ответ на Are advisory locks guaranteed to be First Come First Serve? And can the behavior be relied upon?  (Hemil Ruparel <hemilruparel2002@gmail.com>)
Список pgsql-general
Thanks a lot

On Thu 27 Aug, 2020, 12:23 PM Laurenz Albe, <laurenz.albe@cybertec.at> wrote:
On Thu, 2020-08-27 at 10:10 +0530, Hemil Ruparel wrote:
> I was playing with Advisory locks. I opened three connections to the database And obtained
>  a lock with the same key. I noticed that the locks were obtained in the order of requests.
>  I was wondering whether the locks are guaranteed to be First Come First Serve and can this
>  behaviour be relied upon.

Yes - lock requests that block are queued, with later lock requests queued behind previous
ones.  Once a lock gets free, the first in line gets it.

This is the same for all heavyweight locks in PostgreSQL.

Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com

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

Предыдущее
От: Eric Zhu
Дата:
Сообщение: Re: Calling a SQL function inside a C function
Следующее
От: Susan Joseph
Дата:
Сообщение: Re: SSL between Primary and Seconday PostgreSQL DBs