I know for my tiny instance, I've even changed it so I don't hang on to remote posts forever -- If a post hasn't gotten any likes or comments after a few months, it's purged to keep my instance fast and light.

5 million dang posts, almost none of which are never seen or interacted with by a human being! That's really something!