pgvector
by Community
Open-source vector similarity search for Postgres
OSS
pgvector
Added 1 June 2026
Overview
pgvector is an open-source PostgreSQL extension that adds vector data types and similarity search operators to Postgres. It enables approximate nearest neighbor search directly within your database using L2, cosine, and inner product distance metrics. Built in C for performance, it integrates with existing Postgres workflows without requiring a separate vector database.
Best for
Best for
Teams already using Postgres who want vector search without adding infrastructure
Use cases
- Semantic search over embeddings stored in Postgres
- Recommendation systems using vector similarity
- RAG pipelines that query embeddings alongside relational data
Notes
pgvector is an open-source PostgreSQL extension that adds vector data types and similarity search operators to Postgres. It enables approximate nearest neighbor search directly within your database using L2, cosine, and inner product distance metrics. Built in C for performance, it integrates with existing Postgres workflows without requiring a separate vector database.
21,551 stars on GitHub. Last updated 2026-05-30.
Use cases
- Semantic search over embeddings stored in Postgres
- Recommendation systems using vector similarity
- RAG pipelines that query embeddings alongside relational data
Pros
- Runs inside Postgres, eliminating separate vector DB infrastructure
- Supports multiple distance metrics and indexing strategies (HNSW, IVFFlat)
- Active community with 21k+ stars and regular maintenance
Cons
- Performance scales differently than dedicated vector databases at very large scales
- Requires Postgres expertise to optimize indexes and queries
- Limited to Postgres ecosystem, not portable to other databases
Indexed from awesome-llmops and enriched against its public facts.
Pros
- Runs inside Postgres, eliminating separate vector DB infrastructure
- Supports multiple distance metrics and indexing strategies (HNSW, IVFFlat)
- Active community with 21k+ stars and regular maintenance
Cons
- Performance scales differently than dedicated vector databases at very large scales
- Requires Postgres expertise to optimize indexes and queries
- Limited to Postgres ecosystem, not portable to other databases
Pairs with
Other entries in the index that connect to this one. Click through to see the chain.
Milvus
Community
Milvus is a high-performance, cloud-native vector database built for scalable vector ANN search
Qdrant
Community
Qdrant - High-performance, massive-scale Vector Database and Vector Search Engine for the next generation of AI. Also available in the cloud https://cloud.qdrant.io/
Chroma
Community
Search infrastructure for AI
Weaviate
Community
Weaviate is an open-source vector database that stores both objects and vectors, allowing for the combination of vector search with structured filtering with the fault tolerance an
Rivestack
Community
Managed pgvector on dedicated PostgreSQL with NVMe storage. 2,000 QPS at sub-4ms p50, from $35/month, migration help from Supabase, Neon, Pinecone, and self-hosted.
Semantic Cache Router
Community
Distributed semantic cache and stateful routing system that cuts LLM API costs by returning cached responses for semantically similar queries. Uses ANN vector search (cosine ≥ 0.8)
Statewave
Community
Open-source memory runtime for AI agents — reproducible, provenance-tagged context bundles instead of query-time retrieval. Apache-2.0, self-hosted on Postgres + pgvector, Python +
Awadb
Community
AI Native database for embedding vectors
currentslab/awesome-vector-search
Community
Collections of vector search related libraries, service and research papers
ParadeDB
Community
Simple, Elastic-quality search for Postgres
Vearch
Community
Distributed vector search for AI-native applications
AquilaDB
Community
An easy to use Neural Search Engine. Index latent vectors along with JSON metadata and do efficient k-NN search.
Chroma
Community
Search infrastructure for AI
deeplake
Community
Deeplake is AI Data Runtime for Agents. It provides serverless postgres with a multimodal datalake, enabling scalable retrieval and training.
Marqo
Community
Ecommerce Search and Discovery - marqo.ai
Milvus
Community
Milvus is a high-performance, cloud-native vector database built for scalable vector ANN search
Pinecone
Community
Search through billions of items for similar matches to any object, in milliseconds. It’s the next generation of search, an API call away.
Qdrant
Community
Qdrant - High-performance, massive-scale Vector Database and Vector Search Engine for the next generation of AI. Also available in the cloud https://cloud.qdrant.io/
Vearch
Community
Distributed vector search for AI-native applications
VectorChord
Community
Scalable, fast, and disk-friendly vector search in Postgres, the successor of pgvecto.rs.
Weaviate
Community
Weaviate is an open-source vector database that stores both objects and vectors, allowing for the combination of vector search with structured filtering with the fault tolerance an
Get the free Developer’s Field Guide
A 27-page field guide to the AI coding workflow with Claude. Claude Code, MCP servers, the prompt patterns that work, and what to delegate. Free.
Enter your work email. We send it straight over, plus a few short notes worth knowing. Unsubscribe any time.