Re:Postgres Full-Text Search: A search engine in a database
by kalev on Tuesday July 27, 2021 @11:15PM
(#27979904)
This is exactly the issue I’m currently facing. We do a bunch of count queries to calculate facets and am looking for something that can do this out of the box.
I’m glad I came to the same conclusion myself, either solr or elasticsearch might be the way to go. Starting this from scratch, which of the two would you recommend and why?
[ Parent
| on HN ]
Re:Postgres Full-Text Search: A search engine in a database
by Ueland on Wednesday July 28, 2021 @01:34AM
(#27980541)
I myself is currently setting up Solr for a project as my experience with ES as a DevOps is not a happy one. Always nodes/indexes having some kind of problem. In the same time i have also worked with Solr for years before and never met any major issues. It just works and does the job well.
Re:Postgres Full-Text Search: A search engine in a database
by craigds on Wednesday July 28, 2021 @01:35AM
(#27980546)
Unfortunately I don't know enough about elasticsearch to provide a useful comparison. I like the way ES queries are structured JSON instead of obscure compact querystring parameters, but that's not a good reason to choose one over the other :)