db/migrate/20200110072034_add_index_to_tsv.rb


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15

class AddIndexToTsv < ActiveRecord::Migration[5.2]
  disable_ddl_transaction!

  def up
    safety_assured do
      execute 'CREATE INDEX CONCURRENTLY statuses_text_vector_idx ON statuses USING GIN(tsv)'
    end
  end

  def down
    safety_assured do
      execute 'DROP INDEX statuses_text_vector_idx ON statuses'
    end
  end
end