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

There are no comments on this comment yet.