FDuzZvUv

1class AddIndexToColumnsForPostgreSQLTrigram < ActiveRecord::Migration
2  def up
3    execute "create extension if not exists btree_gin;"
4    execute "create extension if not exists btree_gist;"
5
6    # fuzzy search column
7    execute "create index table_fuzzy_column_idx on table using gist(fuzzy_column gist_trgm_ops);"
8    
9    # basic search column
10    execute "create index table_basic_column_idx on table using gin(to_tsvector('english', basic_column));"
11  end
12 
13  def down
14    execute "drop extension if exists btree_gin;"
15    execute "drop extension if exists btree_gist;"
16  end
17end