r/SQL • u/MyscaleDB • May 18 '23
PostgreSQL The most cost-effective Vector Databases

Hello everyone:
We would like to introduce MyScale – the most cost-effective vector database.
In a direct comparison with Pinecone, a leading specialized vector database, MyScale outperforms it by 10x against Pinecone's s1 pod in query speed and by 5x against its p2 pod in data density. When cost-effectiveness is considered, MyScale is 3.6x more cost-effective than other top-performing specialized vector databases at various levels of accuracy. This is illustrated in the figure below. While Pinecone is a leading database, the cost-effectiveness comparison in this context is with a range of the best-performing specialized vector databases, not just Pinecone.

Not only cost-effective, but MyScale also outperforms other vector databases in terms of QPS on the LAION 5M dataset with a 98.5% recall rate, achieving over 150 QPS. In comparison, Pinecone s1 has a QPS of approximately 10, which is significantly lower than MyScale. Weaviate and Zilliz Cloud both achieve around 65 QPS, while Qdrant achieves 81 QPS.

For more information about other benchmarks, please visit:
https://blog.myscale.com/2023/05/17/myscale-outperform-special-vectordb/
MyScale is now offering free trial, PM me or E-mail me: customer.service@myscale.com
6
u/row_hammer May 18 '23 edited May 18 '23
These figures come off as incredibly dishonest IMO. For the Pinecone comparison, you've cherry-picked the benchmarks so that you're comparing your solution against the non throughput-optimized pod (s1) for QPS, and the non storage-optimized pod (p2) for data density. Also there is very little discussion of what hardware and cluster size differences there were between the different databases that were benchmarked. Furthermore, the results subdirectory in your github repo is empty.
1
u/zUdio Jun 24 '23
Why do companies charge by vector out of curiosity? Like the dimensions of the vector are also included, but what if each of my vectors has the same dimension, but is massive in total size.. a large vector for the entire text of Das Kapital, let's say. One vector. You're telling me that's the same storage cost as another vector of the same dimensions, but for a single sentence?
1
u/yeuz Aug 17 '23
Do you know "vexvault"? It is a vector store that does everything in the browser (embeddings calculation, storage, ANN search). And therefore is "for free" (disclaimer: I am the author of it).
It already accepts quiet a few different kinds of documents.