diff options
| author | GitLab Bot <gitlab-bot@gitlab.com> | 2020-07-23 18:27:09 +0000 |
|---|---|---|
| committer | GitLab Bot <gitlab-bot@gitlab.com> | 2020-07-23 18:27:09 +0000 |
| commit | bcc70301531b6c3118120173389f2aaa7452bf11 (patch) | |
| tree | 161f1ee56e15ec9e59f48c5e1a9cb86b62469a49 /db | |
| parent | d47fc5085a706ab37d038636c9d5934da69853f0 (diff) | |
| download | gitlab-ce-bcc70301531b6c3118120173389f2aaa7452bf11.tar.gz | |
Add latest changes from gitlab-org/gitlab@13-2-stable-ee
Diffstat (limited to 'db')
| -rw-r--r-- | db/migrate/20200715202659_add_index_on_package_files_file_store.rb | 17 | ||||
| -rw-r--r-- | db/structure.sql | 3 |
2 files changed, 20 insertions, 0 deletions
diff --git a/db/migrate/20200715202659_add_index_on_package_files_file_store.rb b/db/migrate/20200715202659_add_index_on_package_files_file_store.rb new file mode 100644 index 00000000000..92e8364d22c --- /dev/null +++ b/db/migrate/20200715202659_add_index_on_package_files_file_store.rb @@ -0,0 +1,17 @@ +# frozen_string_literal: true + +class AddIndexOnPackageFilesFileStore < ActiveRecord::Migration[6.0] + include Gitlab::Database::MigrationHelpers + + DOWNTIME = false + + disable_ddl_transaction! + + def up + add_concurrent_index :packages_package_files, :file_store + end + + def down + remove_concurrent_index :packages_package_files, :file_store + end +end diff --git a/db/structure.sql b/db/structure.sql index 4cf825da8c9..a1b294e843d 100644 --- a/db/structure.sql +++ b/db/structure.sql @@ -19852,6 +19852,8 @@ CREATE INDEX index_packages_maven_metadata_on_package_id_and_path ON public.pack CREATE INDEX index_packages_nuget_dl_metadata_on_dependency_link_id ON public.packages_nuget_dependency_link_metadata USING btree (dependency_link_id); +CREATE INDEX index_packages_package_files_on_file_store ON public.packages_package_files USING btree (file_store); + CREATE INDEX index_packages_package_files_on_package_id_and_file_name ON public.packages_package_files USING btree (package_id, file_name); CREATE INDEX index_packages_packages_on_name_trigram ON public.packages_packages USING gin (name public.gin_trgm_ops); @@ -23862,6 +23864,7 @@ COPY "schema_migrations" (version) FROM STDIN; 20200712235622 20200713071042 20200713152443 +20200715202659 20200716044023 20200716120419 \. |