@feld @Moon The solution is way simpler than this. Soft delete. The reason deletes destroy performance is because of the million indexes on objects. Just add a "deleted_at" column to objects, and query it out in selects. You can batch delete them with cron later. This is what Mastodon does in modern versions and it's why they aren't affected by this problem.