> 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...