Strong take on keeping embeddings in PostgreSQL instead of a separate vector store. We made the same decision for a document search system — single-transaction writes between documents and their embeddings eliminated an entire class of consistency bugs we had with a Pinecone setup. The tradeoff showed up at around 2M vectors where pgvector query latency started climbing, but HNSW indexing brought it back under 50ms.