"Jonathan Bond-Caron" <jbondc@xxxxxxxxx> writes: > It would be quite useful to implement a database queue. Although FOR UPDATE > NOWAIT and trying again can work as well as other techniques, > just skipping over the locks has its advantages (simplicity and zero wait) And disadvantages, such as complete lack of predictability or failure detection. regards, tom lane
