3 ms·
Postgres and the likes allows trigram indexes for like queries, and expression based indexes just fine. This argument doesn't really pass the smell test.
by tehlike 6y ago
Postgres and the likes allows trigram indexes for like queries, and expression based indexes just fine.
This argument doesn't really pass the smell test.
- kyrra 6y agoI learned about trigrams when working on a personal project and trying to figure out how to do full text searches on postgres. Good blog post about it : https://about.gitlab.com/blog/2016/03/18/fast-search-using-postgresql-trigram-indexes/ https://about.gitlab.com/blog/2016/03/18/fast-search-using-p... The docs: https://www.postgresql.org/docs/current/pgtrgm.html https://www.postgresql.org/docs/current/pgtrgm.html