diff options
| author | Roger Braun <rbraun@Bobble.local> | 2017-10-23 18:30:09 +0200 |
|---|---|---|
| committer | Roger Braun <rbraun@Bobble.local> | 2017-10-23 18:30:09 +0200 |
| commit | 9f417fd5e9893b095041702a6bd0190c7f1d7f22 (patch) | |
| tree | df87e159d5b6e49475909f75f8334c80c3f37f15 /priv | |
| parent | 5912dd0f5dfaecc3732d2174867490c5a6b88c11 (diff) | |
| download | pleroma-9f417fd5e9893b095041702a6bd0190c7f1d7f22.tar.gz pleroma-9f417fd5e9893b095041702a6bd0190c7f1d7f22.zip | |
Speed up deletion and related queries.
Diffstat (limited to 'priv')
| -rw-r--r-- | priv/repo/migrations/20171023155035_add_second_object_index_to_activty.exs | 10 |
1 files changed, 10 insertions, 0 deletions
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 |