pgvector
FreeOpen-source vector extension for PostgreSQL — the default choice for SQL + embeddings.
Tool Info
Overview
pgvector adds vector similarity search to PostgreSQL.
It is the most common choice when teams want SQL, joins, and embeddings in one database.
Supported by Supabase, Neon, RDS, and most Postgres hosts.
Features
- HNSW and IVFFlat indexes
- SQL joins with vectors
- Supabase and Neon support
- ACID transactions
Pricing
Pros
- No new database
- Transactional consistency
- Massive hosting support
Best For
When NOT to Use
- Performance limits at very large scale
- Tuning required for millions of vectors
Typical Users
Community Insights
Real implementation experiences shared by AI practitioners.
Loading practitioner experiences…
Related Tools
Alternatives
Related Architecture Guides
Tags
Related Guides
- Vector Search
Understand how vector databases find similar items using high-dimensional embedding comparisons.
- RAG
A comprehensive guide to RAG - the dominant pattern for building AI applications that answer questions using your own data.
- Embeddings
Discover how AI converts text, images, and data into numerical vectors that capture meaning.
- Metadata Filtering
Pre-filter documents by metadata before vector search - tenant isolation, date ranges, document types, and access control.
- ANN Indexes
Approximate nearest neighbor indexes - HNSW, IVF, IVF-PQ, DiskANN, ScaNN, and flat - that make vector search fast at scale.
- Hybrid Search
Combine keyword and semantic search for more accurate and comprehensive information retrieval.
- Semantic Search
Learn how AI understands the meaning behind queries to find relevant results beyond keyword matching.
- Vector Databases
Purpose-built databases for storing, indexing, and querying embedding vectors at scale — including managed options like Pinecone (Database + Nexus knowledge engine).
- Vector Quantization
Compress embedding vectors with product, scalar, and binary quantization to cut memory and speed ANN search with controlled recall tradeoffs.
Stay Updated
Get the latest AI news, tools, and engineering guides delivered to your inbox.
Subscribe to Newsletter