2 ms·
> I'd probably go with Postgresql FTS if possible. Sphinx/Solr for anything with indices smaller than a couple 100GBs After that, ES seems reasonable & worth th
by riku_iki 7y ago
> I'd probably go with Postgresql FTS if possible. Sphinx/Solr for anything with indices smaller than a couple 100GBs After that, ES seems reasonable & worth the overhead
why do you think you can't throw 1TB of data on postgresql?
- aldoushuxley001 7y agoCould postgres FTS handle millions of documents within a reasonable timeframe?
- manigandham 7y agoYes, it's searching against the ts_vector data types which can be indexed. The problem with PG FTS is that it doesn't have advanced search functionalities (fuzzy matching, faceting, term distance, highlighting results) and it lacks the modern relevance scoring systems so that'll be the limiting factor instead of speed.