From c9aa89e239368d87fc3927a06189cac19948f6d5 Mon Sep 17 00:00:00 2001 From: Alex Gleason Date: Fri, 31 Dec 2021 09:50:44 -0600 Subject: AddObjectConcurrentIndexes: add missing object index --- .../migrations/20211231013155_add_object_concurrent_indexes.exs | 7 +++++++ 1 file changed, 7 insertions(+) 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 -- cgit v1.2.3