pleroma/priv/repo/migrations/20170620095947_remove_activities_index.exs

# Pleroma: A lightweight social networking server
# Copyright © 2017-2022 Pleroma Authors <https://pleroma.social/>
# SPDX-License-Identifier: AGPL-3.0-only

defmodule Pleroma.Repo.Migrations.RemoveActivitiesIndex do
  use Ecto.Migration

  def change do
    drop_if_exists(index(:activities, [:data]))
  end
end
Copyright bump for 2022 2022-02-26 06:11:42 +00:00			`# Pleroma: A lightweight social networking server`
Revert "Merge branch 'copyright-bump' into 'develop'" This reverts merge request !3825 2023-01-02 20:38:50 +00:00			`# Copyright © 2017-2022 Pleroma Authors <https://pleroma.social/>`
Copyright bump for 2022 2022-02-26 06:11:42 +00:00			`# SPDX-License-Identifier: AGPL-3.0-only`

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. 2017-06-20 10:00:58 +00:00			`defmodule Pleroma.Repo.Migrations.RemoveActivitiesIndex do`
			`use Ecto.Migration`

			`def change do`
Enable `mix format` for migrations 2019-10-08 12:16:39 +00:00			`drop_if_exists(index(:activities, [:data]))`
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. 2017-06-20 10:00:58 +00:00			`end`
			`end`