Learn
Deep dive into search concepts, and learn how to build powerful search features in Postgres.
What is pgvector?
Learn about pgvector, the PostgreSQL extension that adds vector data types and similarity search for embeddings and AI workloads.
Tuning pgvector Performance
Learn how to optimize pgvector performance for efficient vector similarity search in PostgreSQL.
pgvector Limitations
Understand the practical limits of pgvector: index cost, filtered search performance, missing features, and operational tradeoffs.
What is Block WAND?
Learn about Block-Max WAND, the dynamic pruning algorithm that accelerates top-k document retrieval in search engines.
What is pgrx?
Learn about pgrx, the Rust framework for building PostgreSQL extensions with memory safety and modern tooling.
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 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 Hybrid Search?
Learn about hybrid search systems that combine lexical and semantic search for comprehensive results.
What is BM25?
Learn about BM25, the ranking algorithm that powers modern search engines.