Add (creator_id, id) index to blocks table

[rails.git] / db / migrate / 20240405083825_add_creator_index_to_user_blocks.rb

diff --git a/db/migrate/20240405083825_add_creator_index_to_user_blocks.rb b/db/migrate/20240405083825_add_creator_index_to_user_blocks.rb
new file mode 100644 (file)
index 0000000..542a102
--- /dev/null
+++ b/db/migrate/20240405083825_add_creator_index_to_user_blocks.rb
@@ -0,0 +1,7 @@
+class AddCreatorIndexToUserBlocks < ActiveRecord::Migration[7.1]
+  disable_ddl_transaction!
+
+  def change
+    add_index :user_blocks, [:creator_id, :id], :algorithm => :concurrently
+  end
+end