mobilizon/priv/repo/migrations/20220321154142_swap_primary_oban_indexes.exs

26 lines
515 B
Elixir
Raw Permalink Normal View History

defmodule Mobilizon.Storage.Repo.Migrations.SwapPrimaryObanIndexes do
use Ecto.Migration
@disable_ddl_transaction true
@disable_migration_lock true
def change do
create_if_not_exists(
index(
:oban_jobs,
[:state, :queue, :priority, :scheduled_at, :id],
concurrently: true,
prefix: "public"
)
)
drop_if_exists(
index(
:oban_jobs,
[:queue, :state, :priority, :scheduled_at, :id],
prefix: "public"
)
)
end
end