Fully concur, in case of SSB the size of your `.ssb` dir grows at alarming rate as you follow more people.
You can however periodically delete the whole dir and as long as you preserve your secret key it will over time download all messages you ever followed *and* your own posts too from the others.
I don't think there's a reasonable compromise here but eternal storage isn't really what I'm looking for in social network...