Vector DB — which one and why?
mediumAnswer
- (1) Pinecone: SaaS, ease of use, expensive at scale.
- (2) Weaviate: OSS + SaaS, GraphQL, built-in vectorizer.
- (3) Qdrant: OSS Rust, high performance, self-host friendly.
- (4) Milvus: OSS, most scale-proven, complex ops.
- (5) pgvector: Postgres extension, simple stack.
- (6) FAISS: library not DB, best for offline.
- (7) Chroma: embedded, dev-friendly.
- (8) Elasticsearch / OpenSearch: mature + hybrid search.
- Modern trend: pgvector for small teams, Qdrant/Milvus for scale.
Check yourself — multiple choice
- Random
- Pinecone SaaS easy expensive / Weaviate OSS+SaaS GraphQL / Qdrant OSS Rust fast / Milvus scale-proven / pgvector Postgres simple / FAISS offline lib / Chroma embedded dev / ES hybrid; pgvector small, Qdrant/Milvus scale
- Just one
- Not real
Vector DB: Pinecone / Weaviate / Qdrant / Milvus / pgvector / FAISS / Chroma / ES.
#llmops#infrastructure
Practise MLOps & Data Quality
215 interview questions in this topic.
Related questions
- Online vs offline feature store — architecture.
- How do you compute real-time features (streaming aggregates)?
- Orchestration tools for ML pipelines — Airflow vs Prefect vs Dagster.
- Why partition ML training tables by date?
- What is an 'asset' in Dagster and why is it useful for ML?
- Push vs pull materialization for features.