Well, that’s interesting, there’s a timer on WhatsApp edits.
I’d implement the same at their scale, have hot append-only data storage for recent messages and then move them to faster read-only storage by consolidation, but I don’t remember seeing that documented anywhere.