podcasts / Gaurav Sen / episode / question
Question

Why use a vector database instead of Postgres for RAG embeddings?

Answered from AI Interview #6 - 1M context window in LLM? · Gaurav Sen · 2026-09-22

When the interviewer says the company already runs Postgres, Tanishka argues that a traditional SQL index compares values along one dimension, while an embedding is a vector with many dimensions. Tanishka cites 768-dimension vectors per chunk, with some embedding models going up to 8,192, and says comparing those is what a vector database is built for.

▸In their words

“in SQL you can only do it in one dimension, right?” Tanishka · at 1:36 — open in the transcript →

Source: our own transcription of the episode. The full conversation is on Gaurav Sen (2026-09-22). Read the whole episode summary →

▸More from this episode

Q1How does RAG work, according to Gaurav Sen's AI interview #6?Q3How many chunks should a RAG pipeline retrieve per query?Q4Does RAG reduce LLM hallucination?Q5How do you handle PDF tables and scanned images in a RAG pipeline?
Transcribe your links. Paste a YouTube, Google Drive or podcast link and WhipScribe gives you the transcript. Transcribe a link →