@drq@mastodon.ml @lamp@mastodong.lol People call it "Pleroma database rot". After reaching a critical point, query time goes to the moon and the instance became completely unusable. The only workarounds are vacuum the database, rebuild the index, and upgrade the hardware, but only with limited effectiveness.