[GENERAL] Order of granting with many waiting on one lock

2013-02-10 Thread Chris Angelico
I've poked around a bit with my good friend Google Search and come up blank, and I'm fairly sure this is something that shouldn't be relied upon, but it's a point of curiosity. Suppose I have twenty processes that all request the same lock. (I'm working with pg_advisory_xact_lock, but any

Re: [GENERAL] Order of granting with many waiting on one lock

2013-02-10 Thread Pavan Deolasee
On Mon, Feb 11, 2013 at 12:26 PM, Chris Angelico ros...@gmail.com wrote: Is there any sort of guarantee that all the processes will eventually get a turn, or could two processes handball the lock to each other and play keepings-off against the other eighteen? That should not happen. There

Re: [GENERAL] Order of granting with many waiting on one lock

2013-02-10 Thread Chris Angelico
On Mon, Feb 11, 2013 at 6:12 PM, Pavan Deolasee pavan.deola...@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