Re:PostgreSQL for Everything
by cauchyk on Wednesday August 19, 2026 @12:05PM
(#49363406)
as someone who loves postgres, this take is getting pretty old. yes we can do quite a bit with extensions but extensions often need to interface with external systems and even then managed providers don't consistently support all extensions. some gaps: bm25 indexes, olap support, also extensions also run into licensing restrictions.
[ Parent
| on HN ]
Re:PostgreSQL for Everything
by jankovicsandras on Thursday August 20, 2026 @03:00AM
(#49371344)
You can do BM25 and hybrid search in Postgres.
Shameless plug: https://github.com/jankovicsandras/plpgsql_bm25 BM25 search implemented in PL/pgSQL ( Unlicense / Public domain )
The repo includes also plpgsql_bm25rrf.sql : PL/pgSQL function for hybrid search ( plpgsql_bm25 + pgvector ) with Reciprocal Rank Fusion; and Jupyter notebook examples.