pgvector (Postgres)
7.0/10Save $36/yrBest RAG for Postgres teams, vector search beside relational data
Postgres extension adding vector search to Postgres on Supabase, Neon, RDS.
| Plan | Monthly | Annual | What you get |
|---|---|---|---|
| OSS extension | Free | — | Postgres extension with HNSW and IVFFlat indexes for hybrid SQL plus vector queries. |
| Supabase Free | Free | — | 500MB Postgres with pgvector for up to ~5M small vectors free permanently. |
| Neon Launch | $19.00/mo | $228.00/yr | $19 monthly with 10GB autoscaling Postgres and pgvector built in. |
| AWS RDS / Aurora | Free | $0.00/yr | Standard RDS pricing with pgvector preinstalled for combined relational data. |
pgvector is the Postgres-bundled RAG pick and the right call for teams running RAG against existing relational data. Open-source under Apache 2.0 since 2021. The wedge for RAG readers: vector search adds to the Postgres database the team already runs, the only catalog RAG pick where vector retrieval combines with relational data joins in one SQL query for relational-RAG patterns that pure-vector DBs require application-level merging to achieve.
OSS extension ships free as a Postgres extension on any deployment. Supabase Free covers five hundred megabyte Postgres with pgvector for around five million small vectors. Neon Launch is the upgrade tier at nineteen dollars monthly with ten gigabyte autoscaling Postgres and pgvector built in. AWS RDS ships pgvector preinstalled. Most relational-data RAG teams stay on Supabase Free or self-hosted Postgres until vector volume crosses around fifty million vectors.
The trade-off versus Pinecone is feature breadth; pgvector lacks managed serverless and dedicated vector-DB observability. The trade-off versus Qdrant is performance ceiling at scale; pgvector handles up to around fifty million vectors comfortably. For teams running RAG against existing Postgres relational data, pgvector is the right call.
Pros
- Vector search lives alongside relational data in one Postgres database
- Hybrid SQL plus vector queries combine in one query for relational-RAG patterns
- Free on Supabase 500MB tier with around five million small vectors
- Neon Launch upgrade at nineteen dollars monthly with autoscaling Postgres
- Apache 2.0 OSS with broad ecosystem and mature production deployments
Cons
- Scale ceiling around fifty million vectors; dedicated DBs win at higher scale
- No native managed-vector-DB features beyond what Postgres provides
Best for: RAG teams running retrieval against existing Postgres relational data who want vector search in the same database.
- OSS license & sovereignty
- 9
- Query performance
- 8
- Setup complexity
- 9
- Value
- 10
- Support
- 8