pleroma

commit: 3d714f85a86010348a0cbfc76e399b44bb5d8499
parent: 1e6491ec96c3eb4e7ce1ca76b521b892206fac03
Author: Roger Braun <roger@rogerbraun.net>
Date:   Tue, 20 Jun 2017 12:00:58 +0200

Drop the general index on activities.

Indices should be more specific as the general index can lead to
slower queries because postgres can't estimate the specificity of
jsonb indexes very well.

Diffstat:
A
priv/repo/migrations/20170620095947_remove_activities_index.exs
7
+++++++

1 file changed, 7 insertions(+), 0 deletions(-)
diff --git a/priv/repo/migrations/20170620095947_remove_activities_index.exs b/priv/repo/migrations/20170620095947_remove_activities_index.exs
@@ -0,0 +1,7 @@
+defmodule Pleroma.Repo.Migrations.RemoveActivitiesIndex do
+  use Ecto.Migration
+
+  def change do
+    drop index(:activities, [:data])
+  end
+end