pgvector

Open-source vector similarity search for PostgreSQL

GrowingOpen SourceLow lock-in

Pricing

Free tier

Flat rate

Adoption

Stable

License

Open Source

Data freshness

Overview

What is pgvector?

pgvector is an open-source PostgreSQL extension that adds vector similarity search capabilities directly to Postgres. It enables storing and querying embeddings alongside relational data, making it the simplest way to add semantic search and RAG capabilities to existing Postgres-powered applications.

Key differentiator

Open-source vector similarity search for PostgreSQL

Capability profile

Strength Radar

L2 and cosine si…HNSW and IVFFlat…Postgres-nativeSupabase/Neon su…Python & JS clie…

Honest assessment

Strengths & Weaknesses

↑ Strengths

L2 and cosine similarity

HNSW and IVFFlat indexing

Postgres-native

Supabase/Neon support

Python & JS clients

Fit analysis

Who is it for?

✓ Best for

Teams already using PostgreSQL who want to add vector search without adopting a separate vector database

✕ Not a fit for

Applications requiring billion-scale vector search with low latency — use a dedicated vector DB instead

Cost structure

Pricing

Free Tier

Available

Starts at

Free / Open Source

Model

Flat rate

Enterprise

None

Performance benchmarks

How Fast Is It?

Ecosystem

Relationships

Next step

Get Started with pgvector

Step-by-step setup guide with code examples and common gotchas.

View Setup Guide →