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.
PostgreSQL Full-Text Search: tsvector, GIN, and Ranking
Build PostgreSQL full-text search with tsvector, tsquery, GIN indexes, and ts_rank. Follow SQL examples and understand the limits of built-in search.
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.
Reciprocal Rank Fusion (RRF): Formula and SQL Example
Learn how Reciprocal Rank Fusion combines keyword and vector search rankings, with the RRF formula, a worked example, and PostgreSQL SQL.
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? Formula, Ranking Factors, and Example
Understand the BM25 ranking algorithm, its formula, term frequency, inverse document frequency, and length normalization with a worked example.