Artificial Intelligence
RAG with Postgres and pgvector in production: from PoC to SLO
Embeddings, HNSW indexing, reranking, evaluation, context window, latency under load. Full stack with code and measurable SLOs.
Tag
hnsw
Architecture
How to Install PostgreSQL with pgvector Step by Step
This guide installs PostgreSQL 18.6 with pgvector 0.8.6 on Debian or Ubuntu from the official PGDG repository, or in Docker. It creates a dedicated role and database, tunes memory for production, and explains when HNSW beats IVFFlat, with recall and build times measured on 99,000 embeddings.
Architecture
pgvector in 2024: HNSW Indexes and Real Scaling
pgvector matured in 2023-2024 with the HNSW index type and parallel construction that arrived in version 0.6. For projects already running PostgreSQL, a dedicated vector database is not needed in most cases: this guide explains when PostgreSQL is enough, how to configure the index, and where it starts to fall short.