A team is building a RAG application and needs a vector database that also lets them keep their existing relational schema and run standard SQL joins against metadata columns. Which AWS option is the canonical fit?

• AAmazon RDS for PostgreSQL with the pgvector extension
• BAmazon DynamoDB with a single-table design
• CAmazon S3 with no indexing
• DAmazon EBS attached to a single EC2 instance