Re:Postgres Full-Text Search: A search engine in a database
by e12e on Tuesday July 27, 2021 @01:17PM
(#27974936)
Even if using ILIKE over the result of an imprecise query?
[ Parent
| on HN ]
Re:Postgres Full-Text Search: A search engine in a database
by mjewkes on Tuesday July 27, 2021 @08:30PM
(#27979186)
ILIKE itself is a linear scan. The only way to index them are trigram indicies, which are very inefficient (and sometimes not usable) if you're searching document-length content.
Whether or not it works in your specific situation depends on your use case.