Hacker News new | ask | show | jobs
by maxnov 4052 days ago
Just wanted to say, I implemented this change and it did really speed things up! Thanks a bunch :) This is the query I went with:

  SELECT d.id, d.meta FROM (
    SELECT id FROM data_rows, to_tsquery('query') AS q
    WHERE tsv @@ q ORDER BY ts_rank_cd(tsv, q) DESC LIMIT 5
  ) AS ids INNER JOIN data_rows d ON d.id = ids.id;
You can see it in action here on the top right: https://lateral.io/visualiser/ted