Some analytics from Nostr.land shows that many old events are rarely requested.
I am considering a dynamic tiering strategy where the age, access frequency and “position” of the event (relative to similar ones) is used to send it off to archival or (more likely) zstd it.
I do not cache indexes due to the high complexity and low benefit.