pgvector for RAG Search: Schema, Storage, and Retrieval, With Real Results

RAG search has four moving parts: split the document, turn text into vectors, store those vectors somewhere queryable, and pull the right ones back out at query time. This post covers the last two — c