For the social media use case of NostrGram I don't see why you would need to store notes in perpetuity, especially since people can easily backup their data or run their own relay for their own history. I tested it early on with NostrGram and virtually nobody ever scrolled past 2-3 days to read the notes.