pleroma

commit: ad79912a0723f4a3e428c125a9c2946831b2cfa8
parent bee8b64fa79b74a8fa9a862956d80018eebc2966
Author: Lain Soykaf <lain@lain.com>
Date:   Fri, 14 Mar 2025 19:53:06 +0400

Create the index concurrently

Diffstat:
M
priv/repo/migrations/20250314153704_add_activities_actor_type_index.exs
9
++++++++-

1 file changed, 8 insertions(+), 1 deletion(-)
diff --git a/priv/repo/migrations/20250314153704_add_activities_actor_type_index.exs b/priv/repo/migrations/20250314153704_add_activities_actor_type_index.exs
@@ -1,7 +1,14 @@
 defmodule Pleroma.Repo.Migrations.AddActivitiesActorTypeIndex do
   use Ecto.Migration
+  @disable_ddl_transaction true
 
   def change do
-    create(index(:activities, ["actor", "(data ->> 'type'::text)", "id DESC NULLS LAST"]))
+    create(
+      index(
+        :activities,
+        ["actor", "(data ->> 'type'::text)", "id DESC NULLS LAST"],
+        concurrently: true
+      )
+    )
   end
 end