Vector Databases Compared: pgvector, Qdrant, Pinecone, Weaviate

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." I