From 347cfcf6495bdd9ad86193b79b57bccea65be29d Mon Sep 17 00:00:00 2001 From: Tomasz Skorupa Date: Mon, 29 Sep 2025 13:42:40 -0400 Subject: [PATCH 1/5] Drop note_uploads Addresses https://gitlab.com/gitlab-org/gitlab/-/issues/398199\#proposal Changelog: removed --- db/docs/{ => deleted_tables}/note_uploads.yml | 2 + ...29170559_drop_note_uploads_foreign_keys.rb | 53 ++++++++++++++ .../20250929171941_drop_note_uploads.rb | 73 +++++++++++++++++++ db/schema_migrations/20250929170559 | 1 + db/schema_migrations/20250929171941 | 1 + db/structure.sql | 60 --------------- spec/db/schema_spec.rb | 1 - spec/lib/gitlab/database/sharding_key_spec.rb | 2 - .../models/user_shared_examples.rb | 1 - 9 files changed, 130 insertions(+), 64 deletions(-) rename db/docs/{ => deleted_tables}/note_uploads.yml (81%) create mode 100644 db/post_migrate/20250929170559_drop_note_uploads_foreign_keys.rb create mode 100644 db/post_migrate/20250929171941_drop_note_uploads.rb create mode 100644 db/schema_migrations/20250929170559 create mode 100644 db/schema_migrations/20250929171941 diff --git a/db/docs/note_uploads.yml b/db/docs/deleted_tables/note_uploads.yml similarity index 81% rename from db/docs/note_uploads.yml rename to db/docs/deleted_tables/note_uploads.yml index eaae33f0f7c2e0..efd2bef0b37adf 100644 --- a/db/docs/note_uploads.yml +++ b/db/docs/deleted_tables/note_uploads.yml @@ -25,3 +25,5 @@ table_size: small gitlab_schema: gitlab_main_org sharding_key: namespace_id: namespaces +removed_by_url: https://gitlab.com/gitlab-org/gitlab/-/merge_requests/206764 +removed_in_milestone: '18.5' diff --git a/db/post_migrate/20250929170559_drop_note_uploads_foreign_keys.rb b/db/post_migrate/20250929170559_drop_note_uploads_foreign_keys.rb new file mode 100644 index 00000000000000..23745cf2c42898 --- /dev/null +++ b/db/post_migrate/20250929170559_drop_note_uploads_foreign_keys.rb @@ -0,0 +1,53 @@ +# frozen_string_literal: true + +class DropNoteUploadsForeignKeys < Gitlab::Database::Migration[2.3] + disable_ddl_transaction! + milestone '18.5' + + FK_USERS = 'fk_rails_67403e76d7' + FK_PROJECTS = 'fk_rails_728a7c799d' + FK_NAMESPACES = 'fk_rails_dc321bb575' + FK_ORGANIZATIONS = 'fk_rails_e5afc14eb7' + + def up + with_lock_retries do + remove_foreign_key_if_exists :users, name: FK_USERS + end + with_lock_retries do + remove_foreign_key_if_exists :projects, name: FK_PROJECTS + end + with_lock_retries do + remove_foreign_key_if_exists :namespaces, name: FK_NAMESPACES + end + with_lock_retries do + remove_foreign_key_if_exists :organizations, name: FK_ORGANIZATIONS + end + end + + def down + add_concurrent_foreign_key( + :note_uploads, :organizations, + column: :organization_id, + on_delete: :cascade, + name: FK_ORGANIZATIONS + ) + add_concurrent_foreign_key( + :note_uploads, :namespaces, + column: :namespace_id, + on_delete: :cascade, + name: FK_NAMESPACES + ) + add_concurrent_foreign_key( + :note_uploads, :projects, + column: :project_id, + on_delete: :cascade, + name: FK_PROJECTS + ) + add_concurrent_foreign_key( + :note_uploads, :users, + column: :uploaded_by_user_id, + on_delete: :nullify, + name: FK_USERS + ) + end +end diff --git a/db/post_migrate/20250929171941_drop_note_uploads.rb b/db/post_migrate/20250929171941_drop_note_uploads.rb new file mode 100644 index 00000000000000..a5e7da709b86d1 --- /dev/null +++ b/db/post_migrate/20250929171941_drop_note_uploads.rb @@ -0,0 +1,73 @@ +# frozen_string_literal: true + +class DropNoteUploads < Gitlab::Database::Migration[2.3] + milestone '18.5' + + def up + drop_table :note_uploads + end + + def down + execute <<~SQL + CREATE TABLE note_uploads ( + id bigint NOT NULL, + size bigint NOT NULL, + model_id bigint NOT NULL, + uploaded_by_user_id bigint, + organization_id bigint, + namespace_id bigint, + project_id bigint, + created_at timestamp without time zone, + store integer DEFAULT 1 NOT NULL, + version integer DEFAULT 1, + path text NOT NULL, + checksum text, + model_type text NOT NULL, + uploader text NOT NULL, + mount_point text, + secret text, + CONSTRAINT check_2849dedce7 CHECK ((char_length(path) <= 511)), + CONSTRAINT check_b888b1df14 CHECK ((char_length(checksum) <= 64)) + ); + + ALTER TABLE ONLY note_uploads + ADD CONSTRAINT note_uploads_pkey PRIMARY KEY (id, model_type); + + CREATE INDEX note_uploads_checksum_idx ON note_uploads USING btree (checksum); + + CREATE INDEX note_uploads_model_id_model_type_uploader_created_at_idx ON note_uploads USING btree (model_id, model_type, uploader, created_at); + + CREATE INDEX note_uploads_namespace_id_idx ON note_uploads USING btree (namespace_id); + + CREATE INDEX note_uploads_organization_id_idx ON note_uploads USING btree (organization_id); + + CREATE INDEX note_uploads_project_id_idx ON note_uploads USING btree (project_id); + + CREATE INDEX note_uploads_store_idx ON note_uploads USING btree (store); + + CREATE INDEX note_uploads_uploaded_by_user_id_idx ON note_uploads USING btree (uploaded_by_user_id); + + CREATE INDEX note_uploads_uploader_path_idx ON note_uploads USING btree (uploader, path); + + ALTER TABLE ONLY uploads_9ba88c4165 ATTACH PARTITION note_uploads FOR VALUES IN ('Note'); + + ALTER INDEX index_uploads_9ba88c4165_on_checksum ATTACH PARTITION note_uploads_checksum_idx; + + ALTER INDEX index_uploads_9ba88c4165_on_model_uploader_created_at ATTACH PARTITION note_uploads_model_id_model_type_uploader_created_at_idx; + + ALTER INDEX index_uploads_9ba88c4165_on_namespace_id ATTACH PARTITION note_uploads_namespace_id_idx; + + ALTER INDEX index_uploads_9ba88c4165_on_organization_id ATTACH PARTITION note_uploads_organization_id_idx; + + ALTER INDEX uploads_9ba88c4165_pkey ATTACH PARTITION note_uploads_pkey; + + ALTER INDEX index_uploads_9ba88c4165_on_project_id ATTACH PARTITION note_uploads_project_id_idx; + + ALTER INDEX index_uploads_9ba88c4165_on_store ATTACH PARTITION note_uploads_store_idx; + + ALTER INDEX index_uploads_9ba88c4165_on_uploaded_by_user_id ATTACH PARTITION note_uploads_uploaded_by_user_id_idx; + + ALTER INDEX index_uploads_9ba88c4165_on_uploader_and_path ATTACH PARTITION note_uploads_uploader_path_idx; + SQL + end +end diff --git a/db/schema_migrations/20250929170559 b/db/schema_migrations/20250929170559 new file mode 100644 index 00000000000000..75a78fe632ac57 --- /dev/null +++ b/db/schema_migrations/20250929170559 @@ -0,0 +1 @@ +cfdc8fd14e444ca89e12a79bea5485ef620e6f061ec154ce6c5bcd0bc1464954 \ No newline at end of file diff --git a/db/schema_migrations/20250929171941 b/db/schema_migrations/20250929171941 new file mode 100644 index 00000000000000..79f36cabfbb26c --- /dev/null +++ b/db/schema_migrations/20250929171941 @@ -0,0 +1 @@ +6950003fd1dc844dc532ae25752144c17e0e6dbdf4e7d0e05adc0bbd2d090464 \ No newline at end of file diff --git a/db/structure.sql b/db/structure.sql index c772285ef9dfb8..b47198f8411c48 100644 --- a/db/structure.sql +++ b/db/structure.sql @@ -20573,27 +20573,6 @@ CREATE SEQUENCE note_metadata_note_id_seq ALTER SEQUENCE note_metadata_note_id_seq OWNED BY note_metadata.note_id; -CREATE TABLE note_uploads ( - id bigint NOT NULL, - size bigint NOT NULL, - model_id bigint NOT NULL, - uploaded_by_user_id bigint, - organization_id bigint, - namespace_id bigint, - project_id bigint, - created_at timestamp without time zone, - store integer DEFAULT 1 NOT NULL, - version integer DEFAULT 1, - path text NOT NULL, - checksum text, - model_type text NOT NULL, - uploader text NOT NULL, - mount_point text, - secret text, - CONSTRAINT check_2849dedce7 CHECK ((char_length(path) <= 511)), - CONSTRAINT check_b888b1df14 CHECK ((char_length(checksum) <= 64)) -); - CREATE TABLE notes ( note text, noteable_type character varying, @@ -30148,8 +30127,6 @@ ALTER TABLE ONLY uploads_9ba88c4165 ATTACH PARTITION issuable_metric_image_uploa ALTER TABLE ONLY uploads_9ba88c4165 ATTACH PARTITION namespace_uploads FOR VALUES IN ('Namespace'); -ALTER TABLE ONLY uploads_9ba88c4165 ATTACH PARTITION note_uploads FOR VALUES IN ('Note'); - ALTER TABLE ONLY uploads_9ba88c4165 ATTACH PARTITION organization_detail_uploads FOR VALUES IN ('Organizations::OrganizationDetail'); ALTER TABLE ONLY uploads_9ba88c4165 ATTACH PARTITION project_import_export_relation_export_upload_uploads FOR VALUES IN ('Projects::ImportExport::RelationExportUpload'); @@ -34140,9 +34117,6 @@ ALTER TABLE ONLY note_diff_files ALTER TABLE ONLY note_metadata ADD CONSTRAINT note_metadata_pkey PRIMARY KEY (note_id); -ALTER TABLE ONLY note_uploads - ADD CONSTRAINT note_uploads_pkey PRIMARY KEY (id, model_type); - ALTER TABLE ONLY notes_archived ADD CONSTRAINT notes_archived_pkey PRIMARY KEY (id); @@ -43078,22 +43052,6 @@ CREATE INDEX namespace_uploads_uploaded_by_user_id_idx ON namespace_uploads USIN CREATE INDEX namespace_uploads_uploader_path_idx ON namespace_uploads USING btree (uploader, path); -CREATE INDEX note_uploads_checksum_idx ON note_uploads USING btree (checksum); - -CREATE INDEX note_uploads_model_id_model_type_uploader_created_at_idx ON note_uploads USING btree (model_id, model_type, uploader, created_at); - -CREATE INDEX note_uploads_namespace_id_idx ON note_uploads USING btree (namespace_id); - -CREATE INDEX note_uploads_organization_id_idx ON note_uploads USING btree (organization_id); - -CREATE INDEX note_uploads_project_id_idx ON note_uploads USING btree (project_id); - -CREATE INDEX note_uploads_store_idx ON note_uploads USING btree (store); - -CREATE INDEX note_uploads_uploaded_by_user_id_idx ON note_uploads USING btree (uploaded_by_user_id); - -CREATE INDEX note_uploads_uploader_path_idx ON note_uploads USING btree (uploader, path); - CREATE UNIQUE INDEX one_canonical_wiki_page_slug_per_metadata ON wiki_page_slugs USING btree (wiki_page_meta_id) WHERE (canonical = true); CREATE INDEX organization_detail_uploads_checksum_idx ON organization_detail_uploads USING btree (checksum); @@ -46264,24 +46222,6 @@ ALTER INDEX index_uploads_9ba88c4165_on_uploaded_by_user_id ATTACH PARTITION nam ALTER INDEX index_uploads_9ba88c4165_on_uploader_and_path ATTACH PARTITION namespace_uploads_uploader_path_idx; -ALTER INDEX index_uploads_9ba88c4165_on_checksum ATTACH PARTITION note_uploads_checksum_idx; - -ALTER INDEX index_uploads_9ba88c4165_on_model_uploader_created_at ATTACH PARTITION note_uploads_model_id_model_type_uploader_created_at_idx; - -ALTER INDEX index_uploads_9ba88c4165_on_namespace_id ATTACH PARTITION note_uploads_namespace_id_idx; - -ALTER INDEX index_uploads_9ba88c4165_on_organization_id ATTACH PARTITION note_uploads_organization_id_idx; - -ALTER INDEX uploads_9ba88c4165_pkey ATTACH PARTITION note_uploads_pkey; - -ALTER INDEX index_uploads_9ba88c4165_on_project_id ATTACH PARTITION note_uploads_project_id_idx; - -ALTER INDEX index_uploads_9ba88c4165_on_store ATTACH PARTITION note_uploads_store_idx; - -ALTER INDEX index_uploads_9ba88c4165_on_uploaded_by_user_id ATTACH PARTITION note_uploads_uploaded_by_user_id_idx; - -ALTER INDEX index_uploads_9ba88c4165_on_uploader_and_path ATTACH PARTITION note_uploads_uploader_path_idx; - ALTER INDEX index_uploads_9ba88c4165_on_checksum ATTACH PARTITION organization_detail_uploads_checksum_idx; ALTER INDEX index_uploads_9ba88c4165_on_model_uploader_created_at ATTACH PARTITION organization_detail_uploads_model_id_model_type_uploader_cr_idx; diff --git a/spec/db/schema_spec.rb b/spec/db/schema_spec.rb index 915f6fd9b6ea04..148745a3988d96 100644 --- a/spec/db/schema_spec.rb +++ b/spec/db/schema_spec.rb @@ -213,7 +213,6 @@ import_export_upload_uploads: %w[model_id], issuable_metric_image_uploads: %w[model_id], namespace_uploads: %w[model_id], - note_uploads: %w[model_id], organization_detail_uploads: %w[model_id], project_import_export_relation_export_upload_uploads: %w[model_id], project_topic_uploads: %w[model_id], diff --git a/spec/lib/gitlab/database/sharding_key_spec.rb b/spec/lib/gitlab/database/sharding_key_spec.rb index bb6eda7f55334f..aaaab61683b2ec 100644 --- a/spec/lib/gitlab/database/sharding_key_spec.rb +++ b/spec/lib/gitlab/database/sharding_key_spec.rb @@ -57,7 +57,6 @@ import_export_upload_uploads.project_id import_export_upload_uploads.namespace_id issuable_metric_image_uploads.namespace_id namespace_uploads.namespace_id - note_uploads.namespace_id organization_detail_uploads.organization_id project_import_export_relation_export_upload_uploads.project_id project_topic_uploads.organization_id @@ -286,7 +285,6 @@ "import_export_upload_uploads" => "https://gitlab.com/gitlab-org/gitlab/-/issues/398199", "issuable_metric_image_uploads" => "https://gitlab.com/gitlab-org/gitlab/-/issues/398199", "namespace_uploads" => "https://gitlab.com/gitlab-org/gitlab/-/issues/398199", - "note_uploads" => "https://gitlab.com/gitlab-org/gitlab/-/issues/398199", "organization_detail_uploads" => "https://gitlab.com/gitlab-org/gitlab/-/issues/398199", "project_import_export_relation_export_upload_uploads" => "https://gitlab.com/gitlab-org/gitlab/-/issues/398199", "project_topic_uploads" => "https://gitlab.com/gitlab-org/gitlab/-/issues/398199", diff --git a/spec/support/shared_examples/models/user_shared_examples.rb b/spec/support/shared_examples/models/user_shared_examples.rb index 6c8990a576b0fa..b1cf517b8e0eff 100644 --- a/spec/support/shared_examples/models/user_shared_examples.rb +++ b/spec/support/shared_examples/models/user_shared_examples.rb @@ -148,7 +148,6 @@ merge_requests_merge_data namespace_uploads organization_detail_uploads - note_uploads packages_composer_packages packages_debian_group_distributions packages_debian_project_distributions -- GitLab From eed7b2b07674f5a836d7d65411cd826d650e6b88 Mon Sep 17 00:00:00 2001 From: Tomasz Skorupa Date: Tue, 30 Sep 2025 09:57:15 -0400 Subject: [PATCH 2/5] fixup! Drop note_uploads --- ...29170559_drop_note_uploads_foreign_keys.rb | 53 ------------------- db/schema_migrations/20250929170559 | 1 - 2 files changed, 54 deletions(-) delete mode 100644 db/post_migrate/20250929170559_drop_note_uploads_foreign_keys.rb delete mode 100644 db/schema_migrations/20250929170559 diff --git a/db/post_migrate/20250929170559_drop_note_uploads_foreign_keys.rb b/db/post_migrate/20250929170559_drop_note_uploads_foreign_keys.rb deleted file mode 100644 index 23745cf2c42898..00000000000000 --- a/db/post_migrate/20250929170559_drop_note_uploads_foreign_keys.rb +++ /dev/null @@ -1,53 +0,0 @@ -# frozen_string_literal: true - -class DropNoteUploadsForeignKeys < Gitlab::Database::Migration[2.3] - disable_ddl_transaction! - milestone '18.5' - - FK_USERS = 'fk_rails_67403e76d7' - FK_PROJECTS = 'fk_rails_728a7c799d' - FK_NAMESPACES = 'fk_rails_dc321bb575' - FK_ORGANIZATIONS = 'fk_rails_e5afc14eb7' - - def up - with_lock_retries do - remove_foreign_key_if_exists :users, name: FK_USERS - end - with_lock_retries do - remove_foreign_key_if_exists :projects, name: FK_PROJECTS - end - with_lock_retries do - remove_foreign_key_if_exists :namespaces, name: FK_NAMESPACES - end - with_lock_retries do - remove_foreign_key_if_exists :organizations, name: FK_ORGANIZATIONS - end - end - - def down - add_concurrent_foreign_key( - :note_uploads, :organizations, - column: :organization_id, - on_delete: :cascade, - name: FK_ORGANIZATIONS - ) - add_concurrent_foreign_key( - :note_uploads, :namespaces, - column: :namespace_id, - on_delete: :cascade, - name: FK_NAMESPACES - ) - add_concurrent_foreign_key( - :note_uploads, :projects, - column: :project_id, - on_delete: :cascade, - name: FK_PROJECTS - ) - add_concurrent_foreign_key( - :note_uploads, :users, - column: :uploaded_by_user_id, - on_delete: :nullify, - name: FK_USERS - ) - end -end diff --git a/db/schema_migrations/20250929170559 b/db/schema_migrations/20250929170559 deleted file mode 100644 index 75a78fe632ac57..00000000000000 --- a/db/schema_migrations/20250929170559 +++ /dev/null @@ -1 +0,0 @@ -cfdc8fd14e444ca89e12a79bea5485ef620e6f061ec154ce6c5bcd0bc1464954 \ No newline at end of file -- GitLab From 5467c206fb700bcc90f8dde6950a07ca3bd52ff1 Mon Sep 17 00:00:00 2001 From: Tomasz Skorupa Date: Thu, 2 Oct 2025 07:49:17 -0400 Subject: [PATCH 3/5] fixup! fixup! Drop note_uploads --- .../20250929171941_drop_note_uploads.rb | 24 +------------------ 1 file changed, 1 insertion(+), 23 deletions(-) diff --git a/db/post_migrate/20250929171941_drop_note_uploads.rb b/db/post_migrate/20250929171941_drop_note_uploads.rb index a5e7da709b86d1..178f941ed533c7 100644 --- a/db/post_migrate/20250929171941_drop_note_uploads.rb +++ b/db/post_migrate/20250929171941_drop_note_uploads.rb @@ -9,29 +9,7 @@ def up def down execute <<~SQL - CREATE TABLE note_uploads ( - id bigint NOT NULL, - size bigint NOT NULL, - model_id bigint NOT NULL, - uploaded_by_user_id bigint, - organization_id bigint, - namespace_id bigint, - project_id bigint, - created_at timestamp without time zone, - store integer DEFAULT 1 NOT NULL, - version integer DEFAULT 1, - path text NOT NULL, - checksum text, - model_type text NOT NULL, - uploader text NOT NULL, - mount_point text, - secret text, - CONSTRAINT check_2849dedce7 CHECK ((char_length(path) <= 511)), - CONSTRAINT check_b888b1df14 CHECK ((char_length(checksum) <= 64)) - ); - - ALTER TABLE ONLY note_uploads - ADD CONSTRAINT note_uploads_pkey PRIMARY KEY (id, model_type); + CREATE TABLE note_uploads PARTITION OF uploads_9ba88c4165 FOR VALUES IN ('Note') CREATE INDEX note_uploads_checksum_idx ON note_uploads USING btree (checksum); -- GitLab From 068f378bf315d3b7dcca9995cb22c98432dd8c69 Mon Sep 17 00:00:00 2001 From: Tomasz Skorupa Date: Thu, 2 Oct 2025 08:02:11 -0400 Subject: [PATCH 4/5] fixup! fixup! fixup! Drop note_uploads --- db/post_migrate/20250929171941_drop_note_uploads.rb | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/db/post_migrate/20250929171941_drop_note_uploads.rb b/db/post_migrate/20250929171941_drop_note_uploads.rb index 178f941ed533c7..3aed8d02a856c3 100644 --- a/db/post_migrate/20250929171941_drop_note_uploads.rb +++ b/db/post_migrate/20250929171941_drop_note_uploads.rb @@ -9,7 +9,7 @@ def up def down execute <<~SQL - CREATE TABLE note_uploads PARTITION OF uploads_9ba88c4165 FOR VALUES IN ('Note') + CREATE TABLE note_uploads PARTITION OF uploads_9ba88c4165 FOR VALUES IN ('Note'); CREATE INDEX note_uploads_checksum_idx ON note_uploads USING btree (checksum); -- GitLab From 296f4919e7b3a012a09c218396f29fc13681d523 Mon Sep 17 00:00:00 2001 From: Tomasz Skorupa Date: Thu, 2 Oct 2025 11:26:57 -0400 Subject: [PATCH 5/5] fixup! fixup! fixup! fixup! Drop note_uploads --- .../20250929171941_drop_note_uploads.rb | 36 ------------------- 1 file changed, 36 deletions(-) diff --git a/db/post_migrate/20250929171941_drop_note_uploads.rb b/db/post_migrate/20250929171941_drop_note_uploads.rb index 3aed8d02a856c3..f4ae49bb200ad4 100644 --- a/db/post_migrate/20250929171941_drop_note_uploads.rb +++ b/db/post_migrate/20250929171941_drop_note_uploads.rb @@ -10,42 +10,6 @@ def up def down execute <<~SQL CREATE TABLE note_uploads PARTITION OF uploads_9ba88c4165 FOR VALUES IN ('Note'); - - CREATE INDEX note_uploads_checksum_idx ON note_uploads USING btree (checksum); - - CREATE INDEX note_uploads_model_id_model_type_uploader_created_at_idx ON note_uploads USING btree (model_id, model_type, uploader, created_at); - - CREATE INDEX note_uploads_namespace_id_idx ON note_uploads USING btree (namespace_id); - - CREATE INDEX note_uploads_organization_id_idx ON note_uploads USING btree (organization_id); - - CREATE INDEX note_uploads_project_id_idx ON note_uploads USING btree (project_id); - - CREATE INDEX note_uploads_store_idx ON note_uploads USING btree (store); - - CREATE INDEX note_uploads_uploaded_by_user_id_idx ON note_uploads USING btree (uploaded_by_user_id); - - CREATE INDEX note_uploads_uploader_path_idx ON note_uploads USING btree (uploader, path); - - ALTER TABLE ONLY uploads_9ba88c4165 ATTACH PARTITION note_uploads FOR VALUES IN ('Note'); - - ALTER INDEX index_uploads_9ba88c4165_on_checksum ATTACH PARTITION note_uploads_checksum_idx; - - ALTER INDEX index_uploads_9ba88c4165_on_model_uploader_created_at ATTACH PARTITION note_uploads_model_id_model_type_uploader_created_at_idx; - - ALTER INDEX index_uploads_9ba88c4165_on_namespace_id ATTACH PARTITION note_uploads_namespace_id_idx; - - ALTER INDEX index_uploads_9ba88c4165_on_organization_id ATTACH PARTITION note_uploads_organization_id_idx; - - ALTER INDEX uploads_9ba88c4165_pkey ATTACH PARTITION note_uploads_pkey; - - ALTER INDEX index_uploads_9ba88c4165_on_project_id ATTACH PARTITION note_uploads_project_id_idx; - - ALTER INDEX index_uploads_9ba88c4165_on_store ATTACH PARTITION note_uploads_store_idx; - - ALTER INDEX index_uploads_9ba88c4165_on_uploaded_by_user_id ATTACH PARTITION note_uploads_uploaded_by_user_id_idx; - - ALTER INDEX index_uploads_9ba88c4165_on_uploader_and_path ATTACH PARTITION note_uploads_uploader_path_idx; SQL end end -- GitLab