That's mostly how Mastodon servers handle it. You post and post and post, but the oldest stuff starts going away. I think the only instances that keep anything forever are the ones like mastodon.social that's bankrolled by the millionaire who created it