Falling Behind Can Effectively Mean Stopping a Database Query

Sometimes following behind can effectively mean stopping. It's possible to get in a condition where you will never catch up because you're falling behind faster than the data is able to recover. The select for update, I never knew that was a thing. Although that's basically doing the cursor stability more or less where it's locking the read rows. You start seeing this stuff and you're like, well, okay, now we've got to rethink exactly how we do everything.