defmodule MyApp.Repo.Migrations.AddMessagesInsertedAtIndex do
use Ecto.Migration
@disable_ddl_transaction true
@disable_migration_lock true
def change do
create index("messages", ["inserted_at DESC"], concurrently: true)
end
end
if you have multiple Elixir application nodes don't forget set the advisory lock
config :wave, Wave.Repo, migration_lock: :pg_advisory_locke
About the author
- spawn(fn -> @elixirlang/@elmlang developer end)
Comments
Join the discussionNo comments yet. Be the first to comment.
