An app needs to store both the raw text and its embedding in PostgreSQL. What is the recommended table design?
- A Separate tables for text and vectors joined by ID
- B Single table with text column (text), embedding column (vector(1536)), and metadata jsonb (correct answer)
- C Store embeddings in a separate Azure Blob Storage
- D Use Cosmos DB for vectors only
Shortcut: Storing text, embedding, and metadata in a single table simplifies queries and enables efficient hybrid search. The vector column type stores the embedding natively with index support.