Honest pros, cons, and verdict on this ai memory tool
✅ Keeps embeddings and relational data in PostgreSQL.
Starting Price
Free
Free Tier
Yes
Category
AI Memory
Skill Level
Developer
pgvector is an open-source PostgreSQL extension for storing embeddings and running vector similarity search with SQL. It is best for teams already using PostgreSQL that want semantic search, RAG retrieval, or AI memory without operating a separate vector database, while accepting PostgreSQL scaling and tuning tradeoffs.
pgvector is a $0 MIT-licensed PostgreSQL extension for storing embeddings, querying vector similarity with SQL, and keeping RAG, semantic search, recommendations, and AI memory data inside an existing PostgreSQL database instead of adopting a separate vector database, with paid cost coming from PostgreSQL hosting, compute, memory, storage, backups, monitoring, and operations. It adds vector-oriented data types, distance operators, functions, and approximate nearest-neighbor indexing options to PostgreSQL, so developers can store embeddings beside relational records and filter results with normal SQL predicates, joins, roles, transactions, and backup workflows.
Verifiable product facts are central to evaluating pgvector. It is implemented as a PostgreSQL extension. Its public repository is hosted at github.com/pgvector/pgvector. The project uses the MIT license. It supports exact nearest-neighbor search and approximate indexing. The visible feature set includes HNSW indexes and IVFFlat indexes. It supports common vector distance patterns such as L2 distance, inner product, cosine distance, and L1 distance. It also exposes vector-oriented types beyond the standard vector type, including half-precision, binary, and sparse vector options where supported by the installed version. pgvector is accessed through PostgreSQL clients because its API surface is SQL, not a separate hosted service API.
Fully managed vector database for RAG and AI search with serverless storage, hybrid sparse-dense indexes, integrated embedding and rerank models, and managed retrieval workflows.
Starting at Free
Learn more →Open-source AI-native vector and hybrid search database with built-in modules for embedding, generative AI (RAG), reranking, and multimodal data — available self-hosted or as Weaviate Cloud.
Starting at Free
Learn more →Open-source, Rust-built vector similarity search engine with payload filtering, hybrid search, quantization, and a fully managed Qdrant Cloud — popular for RAG, recommendation, and agent memory.
Starting at Free
Learn more →pgvector delivers on its promises as a ai memory tool. While it has some limitations, the benefits outweigh the drawbacks for most users in its target market.
pgvector is an open-source PostgreSQL extension for storing embeddings and running vector similarity search with SQL. It is best for teams already using PostgreSQL that want semantic search, RAG retrieval, or AI memory without operating a separate vector database, while accepting PostgreSQL scaling and tuning tradeoffs.
Yes, pgvector is good for ai memory work. Users particularly appreciate keeps embeddings and relational data in postgresql.. However, keep in mind performance may lag specialized vector databases for very large or distributed workloads..
Yes, pgvector offers a free tier. However, premium features unlock additional functionality for professional users.
pgvector is best for Adding semantic search to an existing PostgreSQL application. and Building retrieval-augmented generation over relational data.. It's particularly useful for ai memory professionals who need vector storage in postgresql tables..
Popular pgvector alternatives include Pinecone, Weaviate, Qdrant. Each has different strengths, so compare features and pricing to find the best fit.
Last verified March 2026