@mackuba.eu I know this because I realized (One Simple Trick™) that I don’t need to recheck all previous posts from 2023-24 that weren’t deleted before every time, twice an hour… and now it only looks at a 1h window of posts.

In Postgres it now takes <2s. In MySQL 9-10s. (But a full query w/o deleting took 2s)