Pleroma and GoToSocial are indeed better if you are looking for something more efficient.

But I am still not happy with the idea that we should be deleting data from the server just to keep it manageable. It reminds of the before Gmail where people would get 5MB quota of Yahoo Mail and would have to go around deleting stuff from their mailboxes every other month.