5 ms·
Postgres (with pgvector) is an unbelievably goated vector db. Idk why anyone would use anything else.
by w1 2y ago
Postgres (with pgvector) is an unbelievably goated vector db. Idk why anyone would use anything else.
- Bella-Xiang 2y agoThere are significant differences in performance, accuracy, and other aspects when using a general-purpose database like PostgreSQL. These differences can lead to bottlenecks in performance and data scale. You can refer to this comparison article to learn more https://myscale.com/blog/myscale-vs-postgres-opensearch/ https://myscale.com/blog/myscale-vs-postgres-opensearch/
- brigadier132 2y agoPgVector stores the index in memory right? Do you really want your primary db using all its memory for vectors and all its cpu for doing vector dot products?
- stephen37 2y agoIt's nice to begin with but you usually quickly hit a scale issue from what I tried and talked to different people using it. Also they only offer index stored in Memory as far as I know, also lack the support of different index or more advanced ones like GPU index. https://zilliz.com/comparison/milvus-vs-pgvector https://zilliz.com/comparison/milvus-vs-pgvector
- trosterud 2y agoAnd Datomic is the goat outside of vectors
- manishsharan 2y agoSo you want to run mission critical workloads on Postgres and do a vector similarity search on the same DB?