Uploaded December 2025 | Updated November 2026, 2 days ago
At AI Dev 25 x NYC, Jacky Liang, Developer Advocate at TigerData, showcased hy AI agents struggle to find the correct documentation and how to fix this using PostgreSQL.
Most production RAG systems fail because vector search alone hallucinates or misses exact term matches in legal clauses, technical specs, and domain-specific content.
This technical talk shows how to implement hybrid retrieval directly in Postgres by combining BM25 statistical ranking with pgvector semantic search.
Attendees will learn how to build a working RAG pipeline that queries knowledge bases with both search phrases and embedding vectors, returning ranked results weighted by both keyword relevance and semantic similarity—eliminating the need for external search infrastructure like Elasticsearch.
----------
Join us at AI Dev 26 x San Francisco! Tickets: ai-dev.deeplearning.ai
At AI Dev 25 x NYC, Jacky Liang, Developer Advocate at TigerData, showcased hy AI agents struggle to find the correct documentation and how to fix this using PostgreSQL.
Most production RAG systems fail because vector search alone hallucinates or misses exact term matches in legal clauses, technical specs, and domain-specific content.
This technical talk shows how to implement hybrid retrieval directly in Postgres by combining BM25 statistical ranking with pgvector semantic search.
Attendees will learn how to build a working RAG pipeline that queries knowledge bases with both search phrases and embedding vectors, returning ranked results weighted by both keyword relevance and semantic similarity—eliminating the need for external search infrastructure like Elasticsearch.
----------
Join us at AI Dev 26 x San Francisco! Tickets: ai-dev.deeplearning.ai










