Add partition_id column to selected CI database tables
What does this MR do and why?
Related to #364393 (closed)
I adds a partition_id
column to six of the largest tables from the CI domain according to https://docs.gitlab.com/ee/architecture/blueprints/ci_data_decay/pipeline_partitioning.html#how-do-we-want-to-partition-cicd-data
I've decided to use 100
as the default value because splitting the existing data into 100 physical partitions would result in tables of around 40 GB
which is under the 100 GB
recommended limit.
Screenshots or screen recordings
Screenshots are required for UI changes, and strongly recommended for all other merge requests.
How to set up and validate locally
Numbered steps to set up and validate the change are strongly suggested.
MR acceptance checklist
This checklist encourages us to confirm any changes have been analyzed to reduce risks in quality, performance, reliability, security, and maintainability.
-
I have evaluated the MR acceptance checklist for this MR.