ERR ORR wrote: > Specifically, I was trying to replicate what is done in this blog post: > http://www.postgresonline.com/journal/archives/212-PostgreSQL-9.1-Trigrams-teaching-LIKE-and-ILIKE-new-tricks.html > Queries which use "WHERE "TST_PAYLOAD" LIKE 'SEAT%'" go to the btree index > as it should. > Queries which use "WHERE "TST_PAYLOAD" LIKE '%EAT%'" *should* use the GIST > index but do a full table scan instead. > (I am looking for names like 'SEATTLE') Have you run VACUUM ANALYZE with the index and data in place (as shown in the blog post? Another conspicuous difference is your explicit use of a COLLATE clause in the index declaration. -Kevin -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
