3 ms·
Absolutely -- this is something I didn't include in the article -- it wasn't really fast-search/type-ahead search per say. Gitlab actually has a great article
by hardwaresofton 4y ago
Absolutely -- this is something I didn't include in the article -- it wasn't really fast-search/type-ahead search per say.
Gitlab actually has a great article about this for those who want to read more:
https://about.staging.gitlab.com/blog/2016/03/18/fast-search-using-postgresql-trigram-indexes/ https://about.staging.gitlab.com/blog/2016/03/18/fast-search...
- ro0ster 4y agoI think it would be useful to include pg_trgm's performance vs others as well. I'm not sure how it compares but in my use case with 200,000 rows it has been "good enough" for <100ms autocomplete.