debian-mirror-gitlab/db/post_migrate/20230419121943_add_namespaces_by_top_level_namespace_index_v2.rb
2023-07-09 08:55:56 +05:30

17 lines
451 B
Ruby

# frozen_string_literal: true
class AddNamespacesByTopLevelNamespaceIndexV2 < Gitlab::Database::Migration[2.1]
disable_ddl_transaction!
INDEX_NAME = 'index_on_namespaces_namespaces_by_top_level_namespace'
def up
unprepare_async_index_by_name :namespaces, INDEX_NAME
prepare_async_index :namespaces, '(traversal_ids[1]), type, id', name: INDEX_NAME
end
def down
unprepare_async_index_by_name :namespaces, INDEX_NAME
end
end