3 ms·
I use both ElasticSearch/OpenSearch and Postgres Full Text Search. It's not even close: Postgres Full Text Search is a kludge compared to Lucene-based services
by jonstewart 4y ago
I use both ElasticSearch/OpenSearch and Postgres Full Text Search.
It's not even close: Postgres Full Text Search is a kludge compared to Lucene-based services. It is better than nothing, so, yes, I agree with the Pareto improvement idea. But it is also much, much worse than a Lucene-based alternative. If you need something and can't support having ElasticSearch/OpenSearch (heck, even Solr) running at the same time to support full text search, then sure, use Postgres FTS. But if the queries are still too slow or you need ranking or other text/information retrieval/NLP-type features, you'll want to give up on Postgres FTS and move to something else.