pgvector PostgreSQL extension for storing vectors and running exact/approximate nearest-neighbor search in SQL. Quick Navigation - Installation: - Core concepts and SQL recipes: - Indexing (HNSW / IVFFlat) and tuning: - Filtering, iterative scans, and performance: - Types and functions reference (vector/halfvec/bit/sparsevec): - Troubleshooting: - Client libraries (priority): - Python: - Go: - Node (JS/TS): - Java: - Swift: When to Use - You need vector similarity search inside Postgres (keep vectors with relational data). - You want SQL-native ANN indexes (HNSW or IVFFlat) with tunable recal…