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 Answer
0
Accepted Answer

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
EXPERT
answered a month ago
  • 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

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions