diff options
| -rw-r--r-- | priv/repo/migrations/20211231013155_add_object_concurrent_indexes.exs | 7 |
1 files changed, 7 insertions, 0 deletions
diff --git a/priv/repo/migrations/20211231013155_add_object_concurrent_indexes.exs b/priv/repo/migrations/20211231013155_add_object_concurrent_indexes.exs index d6809f692..3d112d172 100644 --- a/priv/repo/migrations/20211231013155_add_object_concurrent_indexes.exs +++ b/priv/repo/migrations/20211231013155_add_object_concurrent_indexes.exs @@ -29,5 +29,12 @@ defmodule Pleroma.Repo.Migrations.AddObjectConcurrentIndexes do where: "data->>'type' = 'Create'" ) ) + + create_if_not_exists( + index(:objects, ["(coalesce(data->'object'->>'id', data->>'object'))"], + name: :objects_create_objects_index, + concurrently: true + ) + ) end end |