For the vector database, you will create with Terraform an RDS PostgreSQL database with the pgvector extension. The PostgreSQL database is typically faster for complex queries and data analysis, while MySQL, which you used previously, is more efficient for simpler queries.
Working with Vector DB PostgreSQL provides more capabilities and flexibility.