Postgres + pgvector vs Pinecone: A Production Benchmark to 50M Vector

Most "vector database comparison" posts you'll find online were written in 2023, when pgvector was a research curiosity and Pinecone was the default. Two years later, pgvector handles workloads that we'd assumed only Pinecone could touch. We benchmarked both in production conditions on real client data, and the results changed how we recommend vector infrastructure. This isn't a marketing piece. We've shipped both. We have opinions. We'll show you the numbers. TL;DR For workloads under ~50M vect