Pessimistic detection has potential for live lock.
ggm8
One benefit of pessimistic detection is for when you have high contention for a lock from multiple processors. In such a case, it would be better to abort transactions early so that you avoid a lot of wasted work done by many processors, for just one processor to commit at the end.
Pessimistic detection has potential for live lock.
One benefit of pessimistic detection is for when you have high contention for a lock from multiple processors. In such a case, it would be better to abort transactions early so that you avoid a lot of wasted work done by many processors, for just one processor to commit at the end.