2 ms·
If you mean tsvector/tsquery - https://www.postgresql.org/docs/9.6/textsearch-intro.html https://www.postgresql.org/docs/9.6/textsearch-intro.html - it's very g
by simonw 7d ago
If you mean tsvector/tsquery - https://www.postgresql.org/docs/9.6/textsearch-intro.html https://www.postgresql.org/docs/9.6/textsearch-intro.html - it's very good, but it's missing an important feature: ranking based on the overall document collection.
PostgreSQL built-in FTS provides a score for each row based just on the data for that row.
Relevance algorithms like BM25 take overall corpus statistics into account. If you search for a bunch of words and some of them are less common than others in the overall set of documents, documents that match THOSE words will score higher than matches for other words in your search.
That's what all of these additional extensions are providing.
- groundzeros2015 5d ago> ranking based on the overall document collection. Thanks for pointing out a real difference.