Do You Actually Need a Separate Vector Database?
Someone on your team says "we're going to need a vector database." For pure retrieval (RAG, document search, similar items), a vector column, an index and an operator in Postgres-compatible SQL handle it. The question that matters is what the query looks like around the vector part: similar items that are in stock, in this region, for this customer, using state that changed seconds ago. Split that across a vector store and your database and you get two systems on two clocks. This explainer walks through embeddings, the honest answer for retrieval, where the split breaks, and similarity search as a clause in a normal SQL query evaluated against one snapshot.
Overview
A short explainer on whether you need a separate vector database: what embeddings are, why retrieval alone rarely needs one, and what goes wrong when similarity search and live state sit in two systems.
Topics Covered
- •Embeddings in 20 seconds
- •The honest answer for pure retrieval
- •Two systems, two clocks: where a separate vector store breaks
- •Similarity search as a clause in a SQL query
- •Why filters, lookups and similarity should read one snapshot
Key Takeaways
- ✓For retrieval alone, a vector column and an index in SQL usually cover it
- ✓Real queries combine similarity with filters and state that changed seconds ago
- ✓A vector store and a database each answer as of a different moment, so the combined result never existed as a whole
- ✓Evaluating similarity, filters and lookups against one snapshot keeps the answer consistent
More Product Demos

The Frozen Score: Account Takeover Approved on a Ten-Hour-Old Risk Score
A short walkthrough of a transfer check that reads a risk score computed at 2 a.m., ten hours before someone else took over the account.

The Peak-Hour Lag: A Velocity Check Counts 3 Card Attempts Out of 9
A short walkthrough of a velocity check that reads a replica at the lunch peak and counts three card attempts when there were nine.

The Agent's Alibi: Two AI Agents Overspend One $5,000 Budget
A short walkthrough of two agents that each read a $5,000 budget and between them commit $7,500.
Ready to get started?
Book a demo to see how Tacnode can power your real-time data infrastructure.
