Postgres Pro
Downloads
Home   >   mailing lists

Re: Order of granting with many waiting on one lock - Mailing list pgsql-general

From Chris Angelico
Subject Re: Order of granting with many waiting on one lock
Date
Msg-id CAPTjJmob17VH08S4cUxthv7+jxtrrXmnXgD=xRM7wFvntKBgfw@mail.gmail.com
Whole thread Raw
In response to Re: Order of granting with many waiting on one lock  (Pavan Deolasee <pavan.deolasee@gmail.com>)
List pgsql-general
Tree view 
On Mon, Feb 11, 2013 at 6:12 PM, Pavan Deolasee
<pavan.deolasee@gmail.com> wrote:
>      * Determine where to add myself in the wait queue.
>      *
>      * Normally I should go at the end of the queue.

Ah! That's perfect. So they'll actually go into perfect strict
round-robin, assuming that there are no other locks coming into play
(which I expect will be the case; I've been careful to avoid
deadlocks).

Thanks Pavan, fast response and perfect information!

ChrisA

pgsql-general by date:

Previous
From: Pavan Deolasee
Date:
Subject: Re: Order of granting with many waiting on one lock
Next
From: Alban Hertroys
Date:
Subject: Re: Upsert Functionality using CTEs