Cleanup cron jobs: batched deletes, archiving and partitions
Why one DELETE of millions of rows hurts the database, deleting in batches with one transaction each, archiving before deleting, DROP PARTITION, observing the job, and a complete purge job in Spring.