Truncate `p_ci_job_definitions` for archived partitions
<!--IssueSummary start-->
<details>
<summary>
Everyone can contribute. [Help move this issue forward](https://handbook.gitlab.com/handbook/marketing/developer-relations/contributor-success/community-contributors-workflows/#contributor-links) while earning points, leveling up and collecting rewards.
</summary>
- [Close this issue](https://contributors.gitlab.com/manage-issue?action=close&projectId=278964&issueIid=552078)
</details>
<!--IssueSummary end-->
## Problem
To further reclaim space on an ongoing basis, with the pipeline archival period enabled on Gitlab.com we could align the creation of CI partitions to a more time based so that archiving old partitions is more straight forward.
Once all pipelines in a partition are archived we can truncate the old partitions, reclaiming space from unused data.
## Dependencies
:warning: Removing archived pipelines is subordinate to https://gitlab.com/groups/gitlab-org/-/epics/19547+ :warning:
## Proposal
Update https://gitlab.com/gitlab-org/gitlab/-/blob/master/app/models/concerns/ci/partitionable.rb?plain=1#L86 for job_definitions and job_definitions_instances models to detach archived partitions.
issue