Add indexes concurrently on PostgreSQL

1 files changed, 9 insertions, 3 deletions

diff --git a/db/migrate/20160412174954_add_ci_commit_indexes.rb b/db/migrate/20160412174954_add_ci_commit_indexes.rb
index 49fbb3e9bdc..4cb61333178 100644
--- a/db/migrate/20160412174954_add_ci_commit_indexes.rb
+++ b/db/migrate/20160412174954_add_ci_commit_indexes.rb
@@ -1,7 +1,13 @@
 class AddCiCommitIndexes < ActiveRecord::Migration
+  disable_ddl_transaction!
+
   def change
-    add_index :ci_commits, [:gl_project_id, :sha]
-    add_index :ci_commits, [:gl_project_id, :status]
-    add_index :ci_commits, [:status]
+    add_index :ci_commits, [:gl_project_id, :sha], index_options
+    add_index :ci_commits, [:gl_project_id, :status], index_options
+    add_index :ci_commits, [:status], index_options
+  end
+
+  def index_options
+    { algorithm: :concurrently } if Gitlab::Database.postgresql?
   end
 end