Creating partitioned routing table for `ci_pipelines` data
Description
This issue is part of the CI/CD data time-decay implementation effort, see more details in the pipeline partitioning design document.
We want to introduce p_ci_pipelines
routing table, that will allow us to attach existing ci_pipelines
table as partition zero.
These merge request demonstrate how this can be done: !84071 (closed), !80186 (closed)
We need to find the best way to create this table, because how we do that depends on what defaults / indexes / etc will be copied from ci_pipelines
. Our initial PoC have shown that inheriting defaults works, but additional benchmarking may be required to find the most optimal way to structure this partitioned schema.
Edited by Grzegorz Bizon