pgvector Review — Self-Hosted AI Tool
Our review of pgvector — features, strengths, and trade-offs.
pgvector is an open-source vector similarity search extension for PostgreSQL. It enables you to store and query high-dimensional vectors alongside your relational data, supporting exact and approximate nearest neighbor search (ANN) with IVFFlat and HNSW indexes. Features include distance functions (L2, cosine, inner product, Hamming, Jaccard) plus halfvec, bit, and sparsevec types. With over 22,000 GitHub stars, it is the most popular PostgreSQL vector extension — a drop-in addition to any Postgres database.