Postgres as a search engine
https://anyblockers.com/posts/postgres-as-a-search-engine
https://news.ycombinator.com/item?id=41343814
Build a retrieval system with semantic, full-text, & fuzzy search in Postgres to be used as a backbone in RAG pipelines.
We’ll combine 3 techniques:
* full-text search with tsvector
* semantic search with pgvector
* fuzzy matching with pg_trgm
* bonus: BM25
https://en.wikipedia.org/wiki/Okapi_BM25
https://blog.paradedb.com/pages/elasticsearch_vs_postgres
https://news.ycombinator.com/item?id=41173288
#RDBMS #postgres #PostgreSQL #databases #search #SearchEngine #LLM #RAG #BM25
Edited 164d ago