Postgres Full-Text Search
Comments discuss PostgreSQL's built-in full-text search capabilities, extensions like pg_trgm and pg_bm25, and comparisons to Elasticsearch or Solr, often advocating it as sufficient for many applications without needing separate search engines.
Activity Over Time
Top Contributors
Keywords
Sample Comments
How does this compare to full text search in Postgres?
If you already use Postgres consider PH full text search first.
With Postgresql you can use pg_trgm, might be not as powerful as what SOLR/ES provides, but easier to run.
Search built using Postgres is underrated. It can do a lot if used properly.
What are you using for full-text search, anything unusual or just postgres built-in search?
How does text search in Postgres compare with Elasticsearch?
Does anybody know how Postgres' fulltext search capabilities/performance compare to using something like ElasticSearch?
Postgres has excellent full text search built in, and we've always had postgres.
You can even do Elastic-level full text search in Postgres with pg_bm25 (disclaimer: I am one of the makers of pg_bm25). Postgres truly rules, agree on the rec :)
If you're using Postgres, it has very acceptable fulltext search builtin that will take you very far.