Thanks a lot On Thu 27 Aug, 2020, 12:23 PM Laurenz Albe, <laurenz.a...@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 > >
