diff options
Diffstat (limited to 'db/post_migrate/20210505092746_create_partial_covering_index_for_pending_builds.rb')
-rw-r--r-- | db/post_migrate/20210505092746_create_partial_covering_index_for_pending_builds.rb | 24 |
1 files changed, 0 insertions, 24 deletions
diff --git a/db/post_migrate/20210505092746_create_partial_covering_index_for_pending_builds.rb b/db/post_migrate/20210505092746_create_partial_covering_index_for_pending_builds.rb deleted file mode 100644 index 81fe65c1945..00000000000 --- a/db/post_migrate/20210505092746_create_partial_covering_index_for_pending_builds.rb +++ /dev/null @@ -1,24 +0,0 @@ -# frozen_string_literal: true - -class CreatePartialCoveringIndexForPendingBuilds < ActiveRecord::Migration[6.0] - include Gitlab::Database::MigrationHelpers - - disable_ddl_transaction! - - EXISTING_INDEX = 'index_ci_builds_runner_id_pending' - NEW_INDEX = 'index_ci_builds_runner_id_pending_covering' - - def up - disable_statement_timeout do - execute "CREATE INDEX CONCURRENTLY #{NEW_INDEX} ON ci_builds (runner_id, id) INCLUDE (project_id) WHERE status = 'pending' AND type = 'Ci::Build'" unless index_exists_by_name?(:ci_builds, NEW_INDEX) - end - - remove_concurrent_index_by_name :ci_builds, EXISTING_INDEX - end - - def down - add_concurrent_index :ci_builds, :runner_id, where: "status = 'pending' AND type = 'Ci::Build'", name: EXISTING_INDEX - - remove_concurrent_index_by_name :ci_builds, NEW_INDEX - end -end |