News for hackers. Stuff that matters.

A comment on Postgres is eating the database world. Parent comment

Re:Postgres is eating the database world by kiwicopple on Friday March 15, 2024 @08:34AM (#39714810)
also with pg_trgm[0] (mentioned by OP) and pgvector for semantic search you have a pretty powerful search toolkit. for example, combining them for Hybrid Search [1]

[0] https://www.postgresql.org/docs/current/pgtrgm.html

[1] Reciprocal Ranked Fusion: https://supabase.com/docs/guides/ai/hybrid-search

[ Parent | on HN ]
Re:Postgres is eating the database world by mistrial9 on Friday March 15, 2024 @03:48PM (#39719915)
the difference is cached/pre-calc results in a (big on disk, expensive to compute) inverted index.. you cannot beat that at runtime
[ Parent | on HN ]