@vkc @t54r4n1 that, and also your database could be heavily taxed, because those tables have to be updated right as you're posting something else, for example, and then multiple queries run concurrently, trying to modify the same table. Depending on how many toots those are, you could have that happen on multiple threads and such, which would explain some of the lag. I'm not sure anymore, does mastodon use postgres or sqlite? with sqlite, this would perhaps be not so taxing, because I remember when I deleted some things from my go to social database, it spiked for a bit but then it went back to consuming the amount of resources it usually does