Show HN: Pg_textsearch – BM25 Ranking for Postgres(docs.tigerdata.com)

  CREATE EXTENSION pg_textsearch;
  CREATE INDEX articles_idx ON articles USING bm25(content);
  SELECT title, content <@> to_bm25query('database performance', 'articles_idx') AS score
  FROM articles
  ORDER BY score
  LIMIT 10;