Hello, a quick question. Let’s say i have a predicate whose values are always of form:
What would be the most efficient index type to use if I want to be able to search for
baz or even
bar.baz? From my testing the term index only separates by whitespace and
@ but not
., but fulltext also does not seem to index it as expected. Should this be then indexed as trigram?
UPDATE: Just found that term also uses
- as separator. Now curious what other separators are valid.