Q. When is Aurora PostgreSQL with pgvector the better vector store for RAG?
A. When the team already runs Postgres and wants metadata filtering as plain WHERE clauses, transactional consistency, and joins to relational data. The trade-off is that HNSW index builds on millions of rows are slow and need tuning.
Why? The discriminator is whether you already live in Postgres, not raw vector speed.