When to choose Vector Search versus other vector database options?

[JasonC]

I am designing a basic RAG application and reviewing vector database options for storing embeddings. Are there any functional differences between using Vector Search versus something like, Postgres on Cloud SQL with pgvector extensions enabled?