> So far we haven't run into this, but we might need to provide an option for an UPDATE to drop locks on retry if deadlock turns into a bigger problem than live

> So far we haven't run into this, but we might need to provide an option for an UPDATE to drop locks on retry if deadlock turns into a bigger problem than livelock. I'm not sure what you mean by that: the design can deadlock but you just have not seen it happening yet? Edit: oh i see in a comment bellow that deadlocks are detected and abort the transaction.