pgvector vs Chroma vs Qdrant: Same Data, Real Results
Same notes, same question, three vector databases on your laptop: pgvector, Chroma and Qdrant, with real output and three classic mistakes.
Video #03 ยท RAG and vector search
Steps in the video
Files
- common.py (26 lines)
- compare.py (65 lines)
- compose.yaml (16 lines)
- gotchas.py (58 lines)
- notes.txt (22 lines)
Tested with
Python 3.12.15 | ollama==0.6.3, psycopg[binary]==3.3.6, pgvector==0.5.1, chromadb==1.5.9, qdrant-client==1.20.0
What this does not show
One question over seven made-up notes on one laptop; no test of speed or scale. The query-plan result is from 10,000 random vectors with an HNSW index. Behaviour is for the pinned versions. Which-to-pick advice is from blog posts, not a benchmark.
Sources
- https://dev.to/jangwook_kim_e31e7291ad98/vector-db-comparison-2026-qdrant-vs-chromadb-vs-pgvector-what-the-benchmarks-actually-show-2m1f
- https://dev.to/jovan_chan_9500711396d4e6/pgvector-vs-chroma-vs-qdrant-for-local-rag-2026-4laa
- https://dev.to/philip_mcclarence_2ef9475/your-pgvector-queries-are-doing-sequential-scans-heres-why-52ae
- https://developers.llamaindex.ai/python/framework/optimizing/rag_failure_mode_checklist/
- https://docs.digitalocean.com/products/vector-databases/postgresql/how-to/index-and-tune/
- https://fixdevs.com/blog/chromadb-not-working/
- https://fixdevs.com/blog/qdrant-not-working/
- https://techsy.io/en/blog/qdrant-vs-chroma-vs-pgvector
- https://theneuralbase.com/qdrant/learn/beginner/dimension-mismatch-errors/
Learning IT by Example.