I tested a version that used advisory locks to make things wait, but it wasn't fine grained, it essentially serialized all transactions, performance was awful