mastodon/db/migrate/20171129172043_add_index_on_stream_entries.rb

9 lines
280 B
Ruby
Raw Permalink Normal View History

class AddIndexOnStreamEntries < ActiveRecord::Migration[5.1]
disable_ddl_transaction!
def change
add_index :stream_entries, [:account_id, :activity_type, :id], algorithm: :concurrently
remove_index :stream_entries, name: :index_stream_entries_on_account_id
end
end