- Newest
- Most votes
- Most comments
Hi,
Rather than OpenSearch, did you explore the pgvector extension of PostgreSQL: it is available on AWS RDS. See https://aws.amazon.com/about-aws/whats-new/2023/05/amazon-rds-postgresql-pgvector-ml-model-integration/ or https://aws.amazon.com/about-aws/whats-new/2023/10/amazon-rds-postgresql-pgvector-hnsw-indexing/
This blog post will also detail the approach: https://aws.amazon.com/blogs/database/building-ai-powered-search-in-postgresql-using-amazon-sagemaker-and-pgvector/
The ability to add columns to your relational tables identifying different users will allow you to obtain the separation that you want.
Best,
Didier
Could this not be done using OpenSearch k-nn search with filters?
As described here: https://opensearch.org/docs/latest/search-plugins/knn/filter-search-knn/
Relevant content
- asked 10 months ago

Hey! An update here. I used this approach and it worked as I needed, thank you!
Hi again! I was doing some tests and I loaded a very long excel file into my pgvector postgresql database. Then I did a query to get the embeddings by the user id, and got the response, but when calling bedrock I got an exception. ValueError: Error raised by bedrock service: An error occurred (ValidationException) when calling the InvokeModel operation: Input is too long for requested model.
How can I manage large volume of data with this approach using RAG?