News for hackers. Stuff that matters.
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?
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.