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.
[ Parent
| on HN ]
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