Previous | Next --- Slide 47 of 65
Back to Lecture Thumbnails
mumen_rider

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.