There's a moment in almost every RAG project where someone asks the question that decides your next two years of ops work: "Do we actually need a vector database, or can Postgres just do this?"

It's a better question than it sounds, because the honest answer isn't "use Pinecone" or "use Postgres."...