At Supabase, they compared the performance of Postgres-based vector database `pgvector` with Pinecone, a fully managed cloud Vector Database designed for storing and searching vector data. They used the ANN Benchmarks methodology to benchmark the two databases on the dbpedia dataset of 1,000,000 OpenAI embeddings. The results showed that `pgvector` outperformed Pinecone in terms of queries per second (QPS) by up to 143% while still being $70 cheaper per month. Pinecone's performance was affected by its proprietary ANN index and lack of support for exact nearest neighbors search or fine-tuning, which limited its accuracy compared to `pgvector`. The comparison highlights the benefits of using a Postgres-based solution for vector data, including better scalability, reliability, and developer experience.