From 9f417fd5e9893b095041702a6bd0190c7f1d7f22 Mon Sep 17 00:00:00 2001 From: Roger Braun Date: Mon, 23 Oct 2017 18:30:09 +0200 Subject: Speed up deletion and related queries. --- .../20171023155035_add_second_object_index_to_activty.exs | 10 ++++++++++ 1 file changed, 10 insertions(+) create mode 100644 priv/repo/migrations/20171023155035_add_second_object_index_to_activty.exs (limited to 'priv') diff --git a/priv/repo/migrations/20171023155035_add_second_object_index_to_activty.exs b/priv/repo/migrations/20171023155035_add_second_object_index_to_activty.exs new file mode 100644 index 000000000..c6df53ec9 --- /dev/null +++ b/priv/repo/migrations/20171023155035_add_second_object_index_to_activty.exs @@ -0,0 +1,10 @@ +defmodule Pleroma.Repo.Migrations.AddSecondObjectIndexToActivty do + use Ecto.Migration + + @disable_ddl_transaction true + + def change do + drop_if_exists index(:activities, ["(data->'object'->>'id')", "(data->>'type')"], name: :activities_create_objects_index) + create index(:activities, ["(coalesce(data->'object'->>'id', data->>'object'))"], name: :activities_create_objects_index, concurrently: true) + end +end -- cgit v1.2.3