## 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 https://gitlab.com/gitlab-org/gitlab/-/issues/520407+