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