PostrgreSQL with Pgvector extension or Astra DB as a vector DB for RAG approach using Bedrock?

0

Hi!

I'm building a RAG approach app using bedrock behind the scenes. I was searching and testing different vectorial databases, but since I need to have more control over the data and filter it per user in my case I'm using PostgreSQL with pgvector. But doing some research I found out about Astra DB.

Which one is better for RAG approach and embeddings? Both are good options? Or One of them is better than the other one?

Thank you!

1 回答
0
已接受的回答

Hi,

I like this post which depicts well the advantages of all possible database types that you can use for embeddings: https://www.linkedin.com/pulse/choosing-vector-database-your-gen-ai-stack-abhinav-srivastava/

Personally, I would initially try with pgvector as it is available on AWS Aurora and see how far I go with it: https://aws.amazon.com/about-aws/whats-new/2023/07/amazon-aurora-postgresql-pgvector-vector-storage-similarity-search/

This post gives the limits of pgvector if you are at really high scale: https://medium.com/@zilliz_learn/getting-started-with-pgvector-a-guide-for-developers-exploring-vector-databases-9c2295bb13e5

Best,

Didier

profile pictureAWS
专家
已回答 4 个月前
  • Thanks man!

  • You're very welcome!

  • When do you think pgvector will be in his limit of data to migrate to a full vectorial database? I'm new in the vectorial DBs and I don't know which will be a good estimate number of rows in PostgreSQL to start considering the migration to a full vectorial DB

    Thanks

您未登录。 登录 发布回答。

一个好的回答可以清楚地解答问题和提供建设性反馈,并能促进提问者的职业发展。

回答问题的准则

相关内容