4 ms·
Even if using ILIKE over the result of an imprecise query?
by e12e 5y ago
Even if using ILIKE over the result of an imprecise query?
- deleted 5y ago[deleted]
- mjewkes 5y agoILIKE 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.