Create a retention policy for ci_pipelines_config
Summary
We store the pipeline yaml configuration for each pipeline into a table called ci_pipelines_config
and this table is getting close to a billion records and currently it's out 12th largest table.
The original purpose for this table was to keep the pipeline configuration around for debugging purposes after the pipeline was created, but the data that's currently stored there is not really useful:
gitlabhq_dblab=# select * from ci_pipelines_config where pipeline_id = 1130832391;
pipeline_id | content
-------------+---------------------------
1130832391 | --- +
| include: +
| - local: ".gitlab-ci.yml"+
|
(1 row)
Proposal
Keep the records for only 1 month.