Skip to main content

One post tagged with "postgres"

View All Tags

Vector search in the Postgres you already run

· 9 min read

When a RAG prototype outgrows its in-memory list, the usual next step is a new piece of infrastructure: a dedicated vector database, with its own deployment, its own backups and a sync job that copies data into it. If you already run Postgres, there is a shorter step. pgvector adds a vector type, distance operators and approximate indexes to the database you already have, and the vectors sit in the same rows as the text they describe.

This post is what I would want to know before putting it in production: the column, the operators, the indexes and their knobs, the filtering trap, and how it looks from .NET.