3 ms·
or, the best of both worlds: like or ilike using a trigram index CREATE INDEX trigram_index ON words_table USING GIN (sentence GIN_TRGM_OPS)
by jerrysievert 7y ago
or, the best of both worlds: like or ilike using a trigram index
CREATE INDEX trigram_index ON words_table USING GIN (sentence GIN_TRGM_OPS)
- jordanthoms 7y agoYeah that index is amazing if you are doing a lot of sliding LIKE queries (i.e. % placeholders at start and end). Speeds them up massively without having to switch to a full text index or change your queries at all.