PostgreSQL as a Vector Database: When to Use pgvector vs Pinecone vs Weaviate

"Should we use PostgreSQL as our vector database?" I've heard this question a lot in 2026. pgvector...