It’s just #Postgres here to do #pg_textsearch

“Most teams work around this by bolting on Elasticsearch or Typesense as a sidecar. That works, but now you are syncing data between two systems, operating two clusters, and debugging consistency issues when they diverge.
pg_textsearch takes a different approach: real BM25 scoring, built from scratch in C on top of Postgres's own storage layer. You create an index, write a query, and get results ranked by relevance”
https://www.tigerdata.com/blog/pg-textsearch-bm25-full-text-search-postgres