pgvector
Open-source vector similarity search for Postgres. The README documents exact and approximate nearest neighbor search, and says to combine it with Postgres full-text search for hybrid search.
- Self-hostable
- yes
- License
- PostgreSQL License
- Hybrid search
- yes
- Metadata filtering
- yes
- Works with
- PostgreSQL
- Managed pricing
- No separate license fee. The extension is under the PostgreSQL License.
- Free tier
- The extension is free. You pay for the Postgres you already run.
- Limits
- README: the vector type stores up to 16,000 dimensions. HNSW indexes vector up to 2,000 dimensions and halfvec up to 4,000. Default hnsw.ef_search is 40.
- Caveats
- The README says approximate indexes apply filters after the scan. With the default hnsw.ef_search of 40, a filter matching 10% of rows returns about 4 rows unless iterative index scans are enabled.