We have never activated the purging of old data before and just run our first archiving task in 12 years. Our database is over 20G in size, and we would like to purge everything that is older than 3 years.
I see the options in the UI to configure automatic purging and see I can schedule it to run daily, weekly or monthly, but I’m afraid it could take too long and timeout for the first run since we have too much data.
The help for the core:purge-old-archive-data console command is a bit confusing. Let’s say I want to delete data in multiple stages (chunks) so it’s more manageable, how should I specify the dates? The description for the parameter refers to months to purge, but then it shows a full date in the example, and referers to the date “from” which to purge.
For example, if I would like to delete 1 year of data per pass starting with the oldest first, how would I specify the date in the console command?