Notes partitioning spike
Background
We encountered some challenges in implementing the partitioning methods initially discussed in #396797 (comment 1675934008). Namely, the presence of the nullable columns made the table harder to partition.
Goals
- Summarize all previous discussions in one place because the
notes
table concerns many stages. - Document the challenges encountered during the previous implementation attempts.
- Explore and investigate more partitioning strategies for the
notes
table. - Decide on another viable strategy for partitioning the
notes
table and document the implementation plan
Edited by euko