4 ms·
With Elasticsearch and Solr, you can easily customize analysis and scoring. There are several scoring algorithms built into them [1] such as BM25 (the default n
by rpedela 10y ago
With Elasticsearch and Solr, you can easily customize analysis and scoring. There are several scoring algorithms built into them [1] such as BM25 (the default now) which is considered the state of the art for keyword relevance. For analysis, you can remove stopwords, stem, apply synonyms, etc [2]. Elasticsearch is specifically designed to scale across multiple machines which is necessary for TB datasets. There are also things like "more like this" queries and context-aware spell checking. Some of that you can do with PG, but not all of it. If PG can do it, it is usually harder to set up.
1. https://www.elastic.co/guide/en/elasticsearch/reference/current/index-modules-similarity.html https://www.elastic.co/guide/en/elasticsearch/reference/curr...
2. https://www.elastic.co/guide/en/elasticsearch/guide/current/analysis-intro.html https://www.elastic.co/guide/en/elasticsearch/guide/current/...
- okket 10y agoThe PostgreSQL team is working on some of the weak spots. Please have a look a the new 'RUM' index, that should improve ranking: https://www.pgcon.org/2016/schedule/attachments/436_pgcon-2016-fts.pdf https://www.pgcon.org/2016/schedule/attachments/436_pgcon-20... https://github.com/postgrespro/rum https://github.com/postgrespro/rum