Some differences between Solr and PostgreSQL Text Search: 1. Solr doesn't handle multi-word synonyms (without a hack), PG does. (ex: "Northern Ireland" => "UK"

Some differences between Solr and PostgreSQL Text Search: 1. Solr doesn't handle multi-word synonyms (without a hack), PG does. (ex: "Northern Ireland" => "UK") 2. Solr uses TF-IDF out of the box, and PG doesn't. 3. PG is good enough for 90% of cases, but Solr has some advanced stuff that PG doesn't. Like integration with OpenNLP, things like the WordDelimiterFilter. (Andre3000 = Andre 3000) 4. PG is kinda annoying in that it will parse "B.C." as a hostname, even though I want it to be a province. 5. Solr is faster than PG, but PG has everything in one server. 6. Solr handles character-grams and word-grams better.