This is technically feasible but a monster of a problem
I am afraid that the trade off of spending say 1 week of careful index shuffling may not be worth it when it comes to correcting this
I can also think of plenty outlier situations that complicate this (like a forum with mountains of short topics)
Let’s wait on this for a bit and see how often it pops up
One interim change we can probably afford on your forum is doubling the size of your recent index, this is configurable (@tgxworld maybe make it so)