From: Tom Hughes <tom@compton.nu>
Date: Thu, 26 Oct 2023 18:58:11 +0000 (+0100)
Subject: Build new relation member indexes concurrently
X-Git-Tag: live~1368
X-Git-Url: https://git.openstreetmap.org./rails.git/commitdiff_plain/0844024c8e68ae0031e143d6094793f0aa32bc22

Build new relation member indexes concurrently
---

diff --git a/db/migrate/20231010194809_correct_relation_members_primary_key.rb b/db/migrate/20231010194809_correct_relation_members_primary_key.rb
index e1f7dcf46..84388063e 100644
--- a/db/migrate/20231010194809_correct_relation_members_primary_key.rb
+++ b/db/migrate/20231010194809_correct_relation_members_primary_key.rb
@@ -2,12 +2,12 @@ class CorrectRelationMembersPrimaryKey < ActiveRecord::Migration[7.0]
   disable_ddl_transaction!
 
   def up
-    alter_primary_key :current_relation_members, [:relation_id, :sequence_id]
-    alter_primary_key :relation_members, [:relation_id, :version, :sequence_id]
+    alter_primary_key :current_relation_members, [:relation_id, :sequence_id], :algorithm => :concurrently
+    alter_primary_key :relation_members, [:relation_id, :version, :sequence_id], :algorithm => :concurrently
   end
 
   def down
-    alter_primary_key :relation_members, [:relation_id, :version, :member_type, :member_id, :member_role, :sequence_id]
-    alter_primary_key :current_relation_members, [:relation_id, :member_type, :member_id, :member_role, :sequence_id]
+    alter_primary_key :relation_members, [:relation_id, :version, :member_type, :member_id, :member_role, :sequence_id], :algorithm => :concurrently
+    alter_primary_key :current_relation_members, [:relation_id, :member_type, :member_id, :member_role, :sequence_id], :algorithm => :concurrently
   end
 end