7 ms·
We use postgres fts and it works fine, you just gotta how you rank order the rows in the query - if you only use ts_rank then it's perfect but you likely want t
by ramraj07 3y ago
We use postgres fts and it works fine, you just gotta how you rank order the rows in the query - if you only use ts_rank then it's perfect but you likely want to use some other relevance metric to adjust the ranking but then you can't rank order primarily by that metric. Once you nail this the results are as fast as any other typical db table query with an index.
- glintik 3y agoActually good ranking is the most valuable thing in search engine.
- qingcharles 3y agoGood ranking is what made Google a trillion dollar company. Google indexed the same sites as Altavista, but Google Page Rank made the right sites bubble to the top and made Sergey and Larry billionaires...
- dgb23 3y agoYou’re right. But at the same time that quality seems to decline or at least stagnate. I think they face the hard problem of an decreasing signal to noise ratio. Ranking is definitely easier when you also provide and moderate the content. That implies the technical solutions might differ qualitatively.
- ramraj07 3y agoWhat I mean is you can't do select * from table where ts_query(...) order by relevance_metric but instead do select * from ( select * from table where ts_query(...) order by ts_rank(...) limit 1000 ) order by relevance_metric limit 10