Learn
Deep dive into search concepts, and learn how to build powerful search features in Postgres.
Introduction to Tantivy
Introduction to Tantivy, a fast full-text search engine library written in Rust
Lexical vs Semantic Search
Learn the differences between lexical and semantic search methods, when to use each approach, and how hybrid search combines both.
What is Faceted Search?
Learn about faceting and faceted search, how they relate to aggregations, and when to use them.
What is RAG?
Learn about retrieval-Augmented Generation (RAG) and how it uses search to increase LLM effectiveness
Full-Text Search in PostgreSQL
Learn how to implement powerful text search directly in PostgreSQL using built-in full-text search capabilities.
Implementing BM25 in PostgreSQL
Learn how to implement BM25 ranking in PostgreSQL using various approaches from SQL to ParadeDB extensions.
What is Full-Text Search?
Learn about full-text search capabilities, how they work, and when to use them in your applications.
What is Hybrid Search?
Learn about hybrid search systems that combine lexical and semantic search for comprehensive results.
What is Reciprocal Rank Fusion?
Learn about Reciprocal Rank Fusion (RRF), a technique for combining multiple search result rankings.
What is Vector Search?
Learn about vector search, how it enables semantic similarity matching using high-dimensional embeddings.
What is BM25?
Learn about BM25, the ranking algorithm that powers modern search engines.