Switch CI auto-partitioning to use time schedule instead of size threhold
Everyone can contribute. Help move this issue forward while earning points, leveling up and collecting rewards.
Problem
Currently CI partitions are created when any partitioned tables reaches a hard-coded size threshold (1TB at the time of this writing).
We discussed that CI partitions could be leveraged when introducing retention policies. For example, rather than deleting pipelines older than 1 year one by one we could record the artifacts to remove in the Ci::DeletedObject table and drop the whole partition.
Proposal
We should look into switching the startegy that automatically creates new partitions, from size threshold to time based. Example: create a new partition every month.
Then surface the configured time limit via Use application settings to configure strategy ... (#520407)