[tmulcahy]

> The lock ordering rules had become too complicated and this was getting us too many transaction restarts, so I stole the standard technique from databases

What is the standard technique from databases?

[koverstreet]

You detect the deadlocks when they happen and abort

[tmulcahy]

Any details/links that explain this? The article seems to suggest that they used to detect the deadlock as it was about to happen, and then abort everything and retry. This doesn't seem too different from "when they happen". What is the optimization?