Power intelligent, real-time search experiences with fast indexing, efficient persistence, and a lean Java backend.
Hi,
PostgreSQL will most likely not use a GIN trigram index, because term + '%' is a prefixed search, and it is perfectly optimized by a btree index over a regular collation (if case is not important - via citext).
Hi,
PostgreSQL will most likely not use a GIN trigram index, because term + '%' is a prefixed search, and it is perfectly optimized by a btree index over a regular collation (if case is not important - via citext).