A reasoned guide to installing PostgreSQL 16 with pgvector on Debian or Ubuntu, choosing between IVFFlat and HNSW, and getting a RAG-ready database into production.
Read moreTag: pgvector
pgvector in 2024: HNSW Indexes and Real Scaling
pgvector matured in 2023-2024 with HNSW and parallel builds. When PostgreSQL is enough for RAG, how to index well, and where it starts to hurt.
Read morepgvector: Semantic Search Without Leaving Postgres
pgvector turns PostgreSQL into a competent vector database. Why semantic search needs specialised indexes and when extending Postgres is enough.
Read more