News for hackers. Stuff that matters.
Re:Creating an advanced search engine with PostgreSQL by glintik on Wednesday July 12, 2023 @04:35PM (#36701273)
Actually good ranking is the most valuable thing in search engine.
Re:Creating an advanced search engine with PostgreSQL by qingcharles on Wednesday July 12, 2023 @06:51PM (#36702734)
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...

Re:Creating an advanced search engine with PostgreSQL by dgb23 on Thursday July 13, 2023 @05:16AM (#36706679)
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.

Re:Creating an advanced search engine with PostgreSQL by ramraj07 on Wednesday July 12, 2023 @09:31PM (#36704010)
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