Just make a cron that runs the rm
command every day or whatever to clean out the files. Then run a SQL query at the same time to truncate any draft posts in the database. There’s no logic to this method, it just clears out the files and records related to draft posts, but it’s fast and effective.
There’s a small chance it might fuck somebody up if they were writing a post at that exact moment, but you can schedule the cron for when your instance is the quietest.
New game, we all take a drink every time somebody makes a post asking when the beta is coming. Last person to die from alcohol poisoning gets access to the beta.