Pgvector

A 10-minute audit of your actual query pattern — recall, corpus size, filters, writes — will tell you whether you need Pinecone or just Postgres, and for most RAG features the honest answer isn't the one every stack diagram assumes.