Skip to content

Draft: Document schema change limitations

Alex Ives requested to merge alexives/document_schema_change_limitations into master

What does this MR do and why?

As tables get larger, we're considering adding new limitations on some actions, with exceptions.

  • Adding a new index or foreign key may only be done on tables under 50gb
  • Adding a new column may only be done on tables under 100gb

This change will be paired with enforcement in the gitlab-com-database-testing project, as well as alerting to teams that have tables in that state.

Related to: gitlab-org/database-team/gitlab-com-database-testing#161 Data: https://gitlab.com/gitlab-org/gitlab/-/issues/477398#note_2120901973 (internal)

MR acceptance checklist

Please evaluate this MR against the MR acceptance checklist. It helps you analyze changes to reduce risks in quality, performance, reliability, security, and maintainability.

Screenshots or screen recordings

Screenshots are required for UI changes, and strongly recommended for all other merge requests.

Before After

How to set up and validate locally

Numbered steps to set up and validate the change are strongly suggested.

Edited by Alex Ives

Merge request reports