> A wildcard at the end can use a regular (btree) index. depending on the locale your db is in, it might be a little less "regular". recently fell in that trap

> A wildcard at the end can use a regular (btree) index. depending on the locale your db is in, it might be a little less "regular". recently fell in that trap. http://blog.cleverelephant.ca/2016/08/pgsql-text-pattern-ops.html http://blog.cleverelephant.ca/2016/08/pgsql-text-pattern-ops...