5 ms·

How does this compare to PostgreSQL?

• wolfgarbe 2y ago
  PostgreSQL is an SQL database that also offers full-text search (FTS), with extensions like pg_search it also supports BM25 scoring which is essential for lexical search. SeekStorm is centered around full-text search only, it doesn't offer SQL. Performance-wise it would be indeed interesting to run a benchmark. The third-party open-source benchmark we are currently using (search_benchmark_game) does not yet support PostgreSQL. So yes, that comparison is still pending.
  • yellow_lead 2y ago
    When I tried to use FTS in Postgres, I got terrible performance, but maybe I was doing something wrong. I'm using Meili now.
    • anonzzzies 2y ago
      Same here, this would easily beat it as far as I have seen, but maybe I did something wrong.
      • philippemnoel 2y ago
        ParadeDB (paradedb.com) is similar to this HN, but baked into Postgres to solve this very problem you are describing