Vector Database Comparison 2026: pgvector, Pinecone, Turbopuffer, and Qdrant

I spent the last two months running the same RAG workload across pgvector, Pinecone, Turbopuffer, and Qdrant on real production traffic. Here is what actually shipped, what broke, and which one I would pick if I were starting a new project this week.