Hacker News Reader

Comment by ramraj07 | Hacker News Reader

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.

View on HN

Actually good ranking is the most valuable thing in search engine.

Good 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...

You’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.

What 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

Reply on news.ycombinator.com