diff options
| author | Roger Braun <roger@rogerbraun.net> | 2017-06-20 12:00:58 +0200 |
|---|---|---|
| committer | Roger Braun <roger@rogerbraun.net> | 2017-06-20 12:00:58 +0200 |
| commit | 3d714f85a86010348a0cbfc76e399b44bb5d8499 (patch) | |
| tree | 0bd30e9f1f9bd8c2f5093cc8fbe470f7b6afbbf0 /priv/repo/migrations/20170620095947_remove_activities_index.exs | |
| parent | 1e6491ec96c3eb4e7ce1ca76b521b892206fac03 (diff) | |
| download | pleroma-3d714f85a86010348a0cbfc76e399b44bb5d8499.tar.gz pleroma-3d714f85a86010348a0cbfc76e399b44bb5d8499.zip | |
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 (limited to 'priv/repo/migrations/20170620095947_remove_activities_index.exs')
| -rw-r--r-- | priv/repo/migrations/20170620095947_remove_activities_index.exs | 7 |
1 files 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 new file mode 100644 index 000000000..85feabeeb --- /dev/null +++ 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 |