(This is incomplete and subject to be expanded) ## Changes we can make to reduce table size 1. https://gitlab.com/gitlab-org/gitlab/-/issues/336233: Skip storing `new_path` unless path got changed (`new_path <> old_path`). Reduction by 31% of total size (https://gitlab.com/gitlab-org/gitlab/-/issues/331787#note_627586699) 1. https://gitlab.com/gitlab-org/gitlab/-/issues/336234: Normalize path attributes into a lookup table. Reduction by 64% of total size (https://gitlab.com/gitlab-org/gitlab/-/issues/331787#note_627593898). Can be done together or without (1). 1. https://gitlab.com/gitlab-org/gitlab/-/issues/336235: Represent modes with integer data types. Marginal reduction only (< 5%). https://gitlab.com/gitlab-org/gitlab/-/issues/331787#note_625126824 1. https://gitlab.com/gitlab-org/gitlab/-/issues/336236: Hash-partition table by `merge_request_diff_id` - ability data to distribute across N partitions (`N = 64`, for example). Reduction to `1/N` per physical table (partition).