pgvector Archives

Building Hybrid Search in PostgreSQL: Combining pgvector and Full-Text Search with Reciprocal Rank Fusion (RRF) for RAG

October 17, 2026

Combine pgvector semantic search with PostgreSQL full-text search using Reciprocal Rank Fusion (RRF). Build a resilient, high-accuracy hybrid retrieval engine for production RAG systems without external vector databases.

Scaling PostgreSQL Vector Search: HNSW Tuning and Table Partitioning for Production RAG

October 11, 2026

Scaling enterprise RAG with PostgreSQL and pgvector demands more than basic indexes. Discover how combining HNSW index tuning with declarative partitioning dropped p95 query latency from 2.8s to 14ms across 8 million vectors.

Database

PostgreSQL pgvector Tutorial: Storing Embeddings and Building Fast Semantic Search

October 2, 2026

Eliminate sync lag and extra infrastructure by moving semantic search into PostgreSQL. Learn how to store embeddings with pgvector, configure HNSW indexes for sub-10ms response times, and implement production-ready hybrid search.

Database

PostgreSQL as a Vector Database: A No-Nonsense Guide to pgvector

April 12, 2026

Don't add another database to your stack. Learn how to use the pgvector extension to turn PostgreSQL into a powerful vector store for AI embeddings and similarity search.