What people actually say about pgvector
83 mentions across 5 sources · 71% positive · researched Aug 6, 2026
Hacker News, YouTube, Stack Overflow, GitHub, Lemmy
What users praise
- • Keeps vector search inside Postgres—no separate infra to manage.
- • ACID transactions, JOINs, and point-in-time recovery work on vectors.
- • Free and open source; huge ecosystem and rapidly growing stars.
What frustrates them
- • HNSW recall and query speed lag specialized vector DBs (Qdrant) on big sets.
- • Hard 2000-dimension cap on HNSW/IVFFlat indexes blocks some embedding models.
- • Filtered searches (e.g., WHERE category=...) are slow and not optimized well.
This is a summary. The full report adds every quote we found, a per-source breakdown, recurring themes, hidden costs and the learning curve — run a free scan below, or see the full pgvector review.
What comes up again and again about pgvector
Recurring themes across everything we collected, with where each one showed up.
Simplifies RAG by eliminating a separate vector database—users love joining vectors with relational data.
praised · seen on YouTube, Hacker News, Lemmy
Performance at scale is the main criticism—recall and speed drop compared to dedicated vector databases.
criticised · seen on Hacker News, GitHub, YouTube
Index dimension limit of 2000 is a recurring pain point for new embedding models.
criticised · seen on GitHub, Stack Overflow
Windows installation is a common stumbling block, pushing users toward Docker or WSL.
criticised · seen on Stack Overflow
Framework integrations (Spring AI, LangChain) have quirks like duplicate index creation and schema errors.
mixed · seen on Stack Overflow, GitHub
Recent features (binary, sparse, disk-based indexes) are seen as a positive sign for scalability in the future.
praised · seen on Lemmy, GitHub
How hard is pgvector to learn?
Users describe it as intermediate · typically A few hours to get going
Where people get stuck
- • Installing compilation dependencies on Windows
- • Understanding index parameters (HNSW m, ef_construction) and their trade-offs
- • Working around the 2000-dimension index limit
Who pgvector actually suits
Works well for
- • Teams already running Postgres who want vector search without extra infrastructure
- • Startups and MVPs building RAG with under a few million vectors
- • Applications that need transactional consistency between vectors and relational data
Not the right fit for
- • Teams at massive scale (>10M vectors) that need top-tier ANN performance
- • Use cases requiring very high-dimensional embeddings (beyond 2000) with indexes
What people are discussing right now
Discussion volume is high and trending up
- Hybrid search patterns with Postgres FTS + pgvector
- Using pgvector for persistent agent memory
- Performance benchmarks vs. dedicated vector databases
What people really think about pgvector
A real-time sweep of the open web — social media, forums, review sites, video reviews and live community discussions — distilled into one honest verdict with the actual mentions behind it.
What's inside your pgvector report
Everything you need to decide — distilled from real, current user opinion.
Live mentions
The actual posts, reviews & complaints about pgvector — with links and dates.
Honest verdict
A straight answer on whether it lives up to the hype — and who it’s really for.
Praise & gripes
What users genuinely love and the frustrations that keep coming up.
Real quotes
Representative voices from real users, not marketing copy.
Recurring themes
The patterns across hundreds of opinions, surfaced at a glance.
Red flags
Hidden costs and dealbreakers people only discover after signing up.
How it works
Sign up free
Create an account in seconds — get 5 free scans, no card.
We sweep the web
Live social media, forums, reviews & video opinions — in ~30–60s.
Get your report
An honest, downloadable verdict with the real mentions behind it.
Ready to see the real verdict on pgvector?
Your scan is ready in under a minute · ₹20 / $1.
Top alternatives to pgvector
Researching options? Explore the closest alternatives.
Milvus
Open-source vector database for billion-scale AI similarity search.
Tidb
Open-source distributed SQL database with vector search, ACID transactions, and HTAP for AI agent workloads.
Doris
Open-source real-time SQL analytics, full-text search, and vector database for AI.
Zvec
Zvec: open-source, in-process vector database with sub-millisecond search at billion scale.
Chromadb Admin
Free open-source admin UI for ChromaDB vector database
Databend
Open-source, cloud-native data warehouse in Rust unifying analytics, vector search, and full-text search on object storage.
Check sentiment on these too
Run a live scan on the alternatives before you decide.
pgvector — questions buyers ask
What do people complain about most with pgvector?
The complaints that recur most often are HNSW recall and query speed lag specialized vector DBs (Qdrant) on big sets, hard 2000-dimension cap on HNSW/IVFFlat indexes blocks some embedding models and filtered searches (e.g., WHERE category=...) are slow and not optimized well. Drawn from 83 mentions across 5 sources.
What do users like about pgvector?
Users consistently praise keeps vector search inside Postgres—no separate infra to manage, ACID transactions, JOINs, and point-in-time recovery work on vectors and free and open source, huge ecosystem and rapidly growing stars.
Is pgvector hard to learn?
Users describe it as intermediate; most people are up and running in a few hours; the usual sticking points are installing compilation dependencies on Windows and understanding index parameters (HNSW m, ef_construction) and their trade-offs.
Who should not use pgvector?
Based on what users report, it is a poor fit for teams at massive scale (>10M vectors) that need top-tier ANN performance and use cases requiring very high-dimensional embeddings (beyond 2000) with indexes.
What are people saying about pgvector right now?
Discussion volume is high and trending up. Current topics: hybrid search patterns with Postgres FTS + pgvector, using pgvector for persistent agent memory and performance benchmarks vs. dedicated vector databases.
How current is this report?
Each scan runs live the moment you click — it reflects what people are saying now, and every report lists the dated mentions behind it.
Can I download it?
Yes — download the full report as a polished, shareable PDF.