3 ms·
A search with an order by/limit across 1 million rows with a GIST trigram index shouldn't be taking multiple seconds if the text being searched isn't huge. In t
by thom 5y ago
A search with an order by/limit across 1 million rows with a GIST trigram index shouldn't be taking multiple seconds if the text being searched isn't huge. In the case of GitHub repository names, you might as well use `similarity` (<->) instead of `word_similarity` (<<->) which would be a speedup, because it's just a pure index scan.