From eaf9bd52890c44b751edc77c9fd31abf301da45c Mon Sep 17 00:00:00 2001 From: gdk Date: Sun, 5 Oct 2025 23:21:41 +0000 Subject: [PATCH] Update table_size database dictionary entries Updates database dictionary entries for `evidences, notes_archived, oauth_access_grant_archived_records, oauth_access_grants`. The classification of table size changed as defined in the [database dictionary](https://docs.gitlab.com/development/database/database_dictionary/#schema). Read more about our process to classify table size in our [documentation](https://docs.gitlab.com/ee/development/database/large_tables_limitations.html). Verify this MR by inspecting the `postgres_table_sizes` view for each affected table. This change was generated by [gitlab-housekeeper](https://gitlab.com/gitlab-org/gitlab/-/tree/master/gems/gitlab-housekeeper) in [CI](https://ops.gitlab.net/gitlab-com/database-team/gitlab-com-database-testing/-/jobs/20561125) using the `Keeps::UpdateTableSizes` keep. To provide feedback on your experience with `gitlab-housekeeper` please create an issue with the label ~"GitLab Housekeeper" and consider pinging the author of this keep. Changelog: added --- db/docs/evidences.yml | 2 +- db/docs/notes_archived.yml | 1 + db/docs/oauth_access_grant_archived_records.yml | 4 ++-- db/docs/oauth_access_grants.yml | 2 +- rubocop/rubocop-migrations.yml | 1 - 5 files changed, 5 insertions(+), 5 deletions(-) diff --git a/db/docs/evidences.yml b/db/docs/evidences.yml index cb75baf5e8c6c4..6503f541fa7d9f 100644 --- a/db/docs/evidences.yml +++ b/db/docs/evidences.yml @@ -8,6 +8,6 @@ description: https://docs.gitlab.com/ee/user/project/releases/#release-evidence introduced_by_url: https://gitlab.com/gitlab-org/gitlab/-/merge_requests/17217 milestone: '12.4' gitlab_schema: gitlab_main_org -table_size: small +table_size: medium sharding_key: project_id: projects diff --git a/db/docs/notes_archived.yml b/db/docs/notes_archived.yml index 5799a91825f6cc..35ab53e3a148ed 100644 --- a/db/docs/notes_archived.yml +++ b/db/docs/notes_archived.yml @@ -9,3 +9,4 @@ description: Temporary archive table for orphaned notes during namespace_id back introduced_by_url: https://gitlab.com/gitlab-org/gitlab/-/merge_requests/201253 milestone: '18.4' gitlab_schema: gitlab_main_org +table_size: small diff --git a/db/docs/oauth_access_grant_archived_records.yml b/db/docs/oauth_access_grant_archived_records.yml index 41286fff526da7..939334ff7a2794 100644 --- a/db/docs/oauth_access_grant_archived_records.yml +++ b/db/docs/oauth_access_grant_archived_records.yml @@ -1,7 +1,7 @@ --- table_name: oauth_access_grant_archived_records feature_categories: - - system_access +- system_access description: | Temporary archive table for deleted `oauth_access_grants` records. Used as a safety net during `oauth_access_grants` retention policy implementation. @@ -16,4 +16,4 @@ sharding_key: notes: | Temporary table for archiving oauth access grants during retention implementation. Will be dropped after verification period. - +table_size: medium diff --git a/db/docs/oauth_access_grants.yml b/db/docs/oauth_access_grants.yml index 75024a16026ea7..2b8cfb1c372dda 100644 --- a/db/docs/oauth_access_grants.yml +++ b/db/docs/oauth_access_grants.yml @@ -11,4 +11,4 @@ milestone: '7.7' gitlab_schema: gitlab_main_org sharding_key: organization_id: organizations -table_size: large +table_size: medium diff --git a/rubocop/rubocop-migrations.yml b/rubocop/rubocop-migrations.yml index d3da07e57a3085..9b1325a530c0a8 100644 --- a/rubocop/rubocop-migrations.yml +++ b/rubocop/rubocop-migrations.yml @@ -47,7 +47,6 @@ Migration/UpdateLargeTable: - :import_source_user_placeholder_references - :lfs_objects_projects - :namespaces - - :oauth_access_grants - :packages_package_files - :personal_access_tokens - :project_authorizations_for_migration -- GitLab