Finally played with
pgvector in production context.- Easy to get started
- Not as fast as specialized DBs
- Good enough for prototypes or moderate scale
If you’re already on Postgres, worth trying before adding another DB.