pgvector instead of a separate vector database
Context: We needed vector search that respects tenant boundaries without operating an extra service.
Decision: Store embeddings in PostgreSQL with pgvector alongside relational data, keeping the stack simple, transactional, and tenant-aware with trivial joins.