Choosing a Vector Database: pgvector vs Dedicated Stores

The real question isn't which vector database is best. It's where your vectors should live: next to the rest of your data in Postgres, or in a system built only for similarity search. Many teams alrea