Actually good ranking is the most valuable thing in search engine.
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 10Google indexed the same sites as Altavista, but Google Page Rank made the right sites bubble to the top and made Sergey and Larry billionaires...
Ranking is definitely easier when you also provide and moderate the content. That implies the technical solutions might differ qualitatively.