Postgres (with pgvector) is an unbelievably goated vector db. Idk why anyone wou...

stephen37 · 2024-04-23T07:50:25

It'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

brigadier132 · 2024-04-23T05:57:19

PgVector 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?

Bella-Xiang · 2024-04-23T05:48:59

There 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/

manishsharan · 2024-04-23T13:37:36

So you want to run mission critical workloads on Postgres and do a vector similarity search on the same DB?

trosterud · 2024-04-23T11:12:30

And Datomic is the goat outside of vectors