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

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!