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...
Source: [Dev.to](https://dev.to/nazar_boyko/vector-databases-compared-pgvector-qdrant-pinecone-weaviate-57an)