4 ms·

How does postgresql's search compare to solr? (With postgresql, I think replicating the search index to read-only nodes is a solved problem.)

• mcfunley 15y ago
  Well, before Etsy switched to Solr we were using postgres tsearch2, and by the end of that search response times were in the 90 second range. And at the time replication wasn't part of postgres so we had a hacked up buggy in-house replicator.
  • mcfunley 15y ago
    And the results were god-awful
    • mcfunley 15y ago
      And we replaced sixteen extremely beefy postgres slaves with four commodity solr boxes with plenty of headroom to spare. (Of course we now have more than four solr slaves.)
• robbyt 15y ago
  Depending on your schema, Solr will be much faster than Psql's full text search. Solr's faceted searching is much faster than table JOINs. But IMHO, the main advantage to use Solr for search instead of Postgres is the query API.