·6 min read
pgvector in Production: High-Scale Vector Search & Hybrid RRF in PostgreSQL
Production guide to pgvector in PostgreSQL: HNSW vs IVFFlat indexing, parameter tuning, hybrid full-text search with RRF, and metadata filtering.
Technical Writings
Stories, tutorials, and deep dives spanning across diverse worlds.
Top Topics
3 results
·12 min read
Vector Databases for Production RAG (2026): Pinecone vs Qdrant vs Milvus vs pgvector
An architectural benchmark of Pinecone, Qdrant, Milvus, and pgvector for production RAG pipelines: HNSW vs IVFFlat indexing, single-stage filtered search, p95 latency, and memory footprint.
·7 min read
Understanding Retrieval-Augmented Generation (RAG)
A deep dive into Retrieval-Augmented Generation (RAG): chunking strategies, vector embeddings, hybrid dense-sparse search, and reranking pipelines.