lib/pghero/methods/suggested_indexes.rb in pghero-1.6.0 vs lib/pghero/methods/suggested_indexes.rb in pghero-1.6.1
- old
+ new
@@ -132,10 +132,10 @@
if total_rows >= 500
if ["~~", "~~*"].include?(where.first[:op])
index[:found] = true
index[:row_progression] = [total_rows, index[:row_estimates].values.first]
- index[:index] = {table: table, columns: ["#{where.first[:column]} gist_trgm_ops"], using: "gist"}
+ index[:index] = {table: table, columns: ["#{where.first[:column]} gin_trgm_ops"], using: "gin"}
else
# if most values are unique, no need to index others
rows_left = total_rows
final_where = []
prev_rows_left = [rows_left]