induwara.lk
induwara.lkDeveloper · AI

Vector Database Comparison: Pinecone vs Weaviate vs Qdrant vs pgvector

A neutral, cited side-by-side of 8vector databases — free tier, license, hosting, max dimensions, index types and hybrid search. Pick 2–6, sort by any column, and read a plain-English “which to choose.” No vendor marketing, no signup, sources linked.

By Induwara AshinsanaUpdated Jun 21, 2026
Compare vector databases
4 of 6 selected

Pick 26 databases. All 8 options stay available below.

Sort by

pgvector (Postgres)

PostgreSQL
Hosting
Postgres extension — self-host or any managed Postgres
Free tier
Free — it is an extension; runs inside Postgres you already have
Max dimensions
2,000 indexed · 16,000 stored
Index types
HNSW · IVFFlat
Hybrid search
Combine vector search with Postgres full-text (tsvector) manually in SQL.
Metadata filter
Yes
Starting price
$0 — runs in your existing Postgres
View pgvector source

Pinecone

Proprietary
Hosting
Managed only (serverless)
Free tier
Starter — free serverless, ~2GB storage, no credit card
Max dimensions
20,000
Index types
Proprietary graph ANN
Hybrid search
First-party
Metadata filter
Yes
Starting price
Standard from $25/mo + usage
View Pinecone source

Qdrant

Apache-2.0
Hosting
Self-host (OSS) + Managed (Qdrant Cloud)
Free tier
Free 1GB managed cluster + unlimited free self-host
Max dimensions
No fixed limit (config-bound)
Index types
HNSW
Hybrid search
First-party
Metadata filter
Yes
Starting price
Usage-based after free 1GB (scales from ~$25/mo)
View Qdrant source

Weaviate

BSD-3-Clause
Hosting
Self-host (OSS) + Managed (Weaviate Cloud)
Free tier
Weaviate Cloud free sandbox + unlimited free self-host
Max dimensions
No fixed limit (memory-bound)
Index types
HNSW · Flat · Dynamic
Hybrid search
First-party
Metadata filter
Yes
Starting price
Serverless Cloud, usage-based (from ~$25/mo)
View Weaviate source

Quick verdict

You already run Postgres and have under ~1M vectors

pgvector

No new infrastructure and one fewer datastore to operate. HNSW indexing inside Postgres comfortably handles up to roughly a million vectors before a dedicated engine pays off.

You want open-source you can self-host, plus a managed cloud option

Qdrant or Weaviate

Both are OSI-licensed (Apache-2.0 / BSD-3), ship first-party hybrid search, and offer a free managed tier — the clean 'start OSS, scale to managed' path.

You want zero operations and have budget for it

Pinecone

Fully managed serverless with no servers to run. The trade-off is proprietary lock-in and per-usage cost once past the free Starter tier.

Verdicts are a fixed decision map keyed to the cells above (open-source flag, free tier, hosting model, index families), not opinion. Only the verdicts that apply to your current selection are shown.

What the terms mean

HNSW
Hierarchical Navigable Small World — a graph index. Fast, high-recall approximate search; the default for most engines, but the full graph lives in RAM.
IVF
Inverted File index — clusters vectors into buckets and searches the nearest few. Lower memory than HNSW, slightly lower recall.
DiskANN
A graph index designed to run from SSD, so billion-scale indexes don't have to fit in RAM. Milvus is the option here that ships it.
Hybrid search
Combining keyword (BM25 / sparse) and vector similarity in one ranked query. 'First-party' means the engine fuses them for you; otherwise you combine results yourself.
All filtering runs in your browser — no account, no network calls. Values are a 2026-06-21 snapshot; confirm at the source links below.

How it works

This is a curated reference tool, not a benchmark or a cost calculator. There is no formula to run — the value is in the data provenance and how each cell is normalized so that columns are genuinely comparable across vendors.

  1. Cell sourcing.Every value is taken from the vendor's own documentation or pricing page — never a third-party blog — and each row links back to that source so you can verify it.
  2. License.We record the exact OSI identifier (Apache-2.0, BSD-3-Clause, PostgreSQL) where one applies, or “Proprietary” / “source-available” with a note. Redis and MongoDB carry licensing caveats because their terms changed over time, so those are flagged rather than simplified.
  3. Free tier.We list the concrete published limit — “1GB managed cluster”, “M0 shared 512MB”, “Starter serverless” — not just “yes”, because the size of the free tier is what actually decides whether you can ship on it.
  4. Max dimensions. The largest indexable vector dimension the docs state. Where indexed and stored limits differ (pgvector caps indexes at 2,000 dimensions but stores up to 16,000), we record both. Where the limit is memory- or config-bound rather than a published hard number, we say so instead of inventing a figure.
  5. Hybrid search.Marked yes only when the engine ships first-party keyword + vector fusion (BM25 or sparse vectors). pgvector and Chroma are marked no because you must combine full-text and vector results yourself — pgvector via Postgres' tsvector, Chroma via your own re-ranking.
  6. Starting paid price.The first paid step above the free tier, with its unit. SaaS pricing drifts, so this is a dated snapshot used mainly for the “starting price” sort — confirm the live figure at the source link before you commit.

The “Quick verdict” panel is a fixed decision map: each recommendation is keyed to the normalized cells above (the open-source flag, free-tier presence, hosting model and index families), not an opinion. As a self-consistency check, the set of databases that are open-source and offer a managed cloud andhave a free tier is computed directly from the table — and it contains Qdrant and Weaviate, exactly the “open-source + managed cloud” recommendation. Because pricing and limits change, every figure is dated with 2026-06-21 and linked to its source so you can re-check it yourself.

Worked examples

“I already run Postgres, ~300k vectors, small team”

Compare pgvector vs Pinecone vs Qdrant

  1. pgvector — License PostgreSQL (free, OSS); runs in your existing Postgres; 2,000 indexed / 16,000 stored dims; HNSW + IVFFlat; hybrid via SQL tsvector; $0 starting price.
  2. Pinecone — Proprietary, managed-only; free Starter serverless tier; 20,000 max dims; first-party hybrid (sparse-dense); paid from $25/mo + usage.
  3. Qdrant — Apache-2.0; free 1GB managed cluster or self-host; first-party hybrid (sparse vectors).
  4. Verdict → pgvector. 300k vectors sits well inside its comfort zone and the team avoids running a second datastore. Maps to “Already on Postgres + <1M vectors”.

“Open-source RAG startup, wants a managed cloud option + hybrid search”

Compare Weaviate vs Qdrant vs Milvus

  1. Weaviate — BSD-3-Clause; OSS + Weaviate Cloud free sandbox; first-party BM25 + vector hybrid.
  2. Qdrant — Apache-2.0; OSS + free 1GB managed cluster; first-party hybrid via sparse vectors.
  3. Milvus / Zilliz — Apache-2.0; OSS + Zilliz Cloud free tier; index families include IVF, HNSW and DiskANN.
  4. Verdict → Weaviate or Qdrant. Both give the “start OSS, scale to managed” path with first-party hybrid; pick Milvus instead only if you specifically need DiskANN for very large on-disk indexes.

“Just prototyping a chatbot in a notebook”

Compare Chroma vs pgvector

  1. Chroma — Apache-2.0; embedded / local mode, no server to run; HNSW; metadata filtering. Fastest path to a working RAG prototype.
  2. pgvector — also free, but assumes you already have a Postgres instance to point at.
  3. Verdict → Chroma for the notebook stage; revisit a server-based engine (or pgvector) once the prototype proves out. Maps to “Prototyping in a notebook”.

Frequently asked questions

Sources & references

Related tools

Rate this tool
Be the first to rate

Comments & feedback

Spotted a bug or want an improvement? Tell us — our team reviews every comment, and good ideas get built. Comments are public and anonymous.

Found a stale figure, a wrong cell, or a database we should add?

Email me at [email protected] — most fixes ship within 24 hours.