5 ms·
PostgreSQL Full-text search is good enough. Also recently in PG12 they did many perf optimizations (Table Partitioning, Indexing, Vacuum) which will help in thi
by truth_seeker 7y ago
PostgreSQL Full-text search is good enough. Also recently in PG12 they did many perf optimizations (Table Partitioning, Indexing, Vacuum) which will help in this regard.
http://rachbelaid.com/postgres-full-text-search-is-good-enough/ http://rachbelaid.com/postgres-full-text-search-is-good-enou...
Text search functions - https://www.postgresql.org/docs/12/functions-textsearch.html https://www.postgresql.org/docs/12/functions-textsearch.html
- deleted 7y ago[deleted]
- bpicolo 7y agoIf you need basic text filtering and ranking, ES is overkill. When you need more powerful ranking, highlighting, etc, postgres isn't as sufficient
- truth_seeker 7y agoNope. PG12 is just fine for any kind of ranking and highlighting. Of course you may have to use extensions like Citus DB to scale horizontally