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.
Whether or not it works in your specific situation depends on your use case.