@Moon good luck, I've suffered with less dramatic but still annoying performance problems for a while now, not sure how much I can do. I wish pleroma offered a way to "reboot" the db in a way that migrates users/follows to new db but ignores posts or just keeps a small amount, most small instances care more about long term scaling over keeping history