diff options
author | GitLab Bot <gitlab-bot@gitlab.com> | 2022-08-04 18:09:24 +0000 |
---|---|---|
committer | GitLab Bot <gitlab-bot@gitlab.com> | 2022-08-04 18:09:24 +0000 |
commit | 2857ba3ce5c9272b99ab2cc4a3d2564504d7ed0e (patch) | |
tree | 68ff07158ac0d73d898fa08a4cbaef52fb535e7a /doc/architecture/blueprints/database_scaling | |
parent | f805496e2f458cc234ac5e52d09fa6d787ccaa97 (diff) | |
download | gitlab-ce-2857ba3ce5c9272b99ab2cc4a3d2564504d7ed0e.tar.gz |
Add latest changes from gitlab-org/gitlab@master
Diffstat (limited to 'doc/architecture/blueprints/database_scaling')
-rw-r--r-- | doc/architecture/blueprints/database_scaling/size-limits.md | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/doc/architecture/blueprints/database_scaling/size-limits.md b/doc/architecture/blueprints/database_scaling/size-limits.md index 45c3f4a659b..284f6402d3c 100644 --- a/doc/architecture/blueprints/database_scaling/size-limits.md +++ b/doc/architecture/blueprints/database_scaling/size-limits.md @@ -136,7 +136,7 @@ As such, the target size of a physical table after refactoring depends on the si There is no standard solution to reduce table sizes - there are many! 1. **Retention**: Delete unnecessary data, for example expire old and unneeded records. -1. **Remove STI**: We still use [single-table inheritance](../../../development/single_table_inheritance.md) in a few places, which is considered an anti-pattern. Redesigning this, we can split data into multiple tables. +1. **Remove STI**: We still use [single-table inheritance](../../../development/database/single_table_inheritance.md) in a few places, which is considered an anti-pattern. Redesigning this, we can split data into multiple tables. 1. **Index optimization**: Drop unnecessary indexes and consolidate overlapping indexes if possible. 1. **Optimise data types**: Review data type decisions and optimise data types where possible (example: use integer instead of text for an enum column) 1. **Partitioning**: Apply a partitioning scheme if there is a common access dimension. |