I added a thing to the prune_objects job to also prune orphaned activities (read: activities who don't have any corresponding object any more).

Last week I ran it and it ran for over 24h, oops. But it had to prune 2 years worth of orphaned activities, so there's that.

Today I ran it again and it only ran ~30minutes.

Now I changed the retention days parameter to keep remote posts with no interaction on the thread for no more than ~6 months (which is probably a lot already) and I have a crontab to run it daily. I want to run it for a while to see I don't have nasty side effects and just to see how it runs, but if all goes well, I can take it out of wip soon 🎉

This should help in keeping DB sizes lower without real loss of quality.