AddRAG

Add RAG to the database you already run.

databases · Extension · checked 2026-11-20

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.

Sources