Skip to index

pgvector

pgvector community

Open source★ #29 in AI Platforms

Product status: Status not recorded

No lifecycle review is recorded for this listing. Its inclusion in the directory does not confirm current availability; check the vendor before relying on it.

No status check date recorded

A PostgreSQL extension for exact and approximate vector search alongside relational data, with HNSW and IVFFlat indexes. No lifecycle review is recorded for this listing. Its inclusion in the directory does not confirm current availability; check the vendor before relying on it.

Product preview

github.com
Preview of pgvector

Decision notes

Official-document research

Based on the cited documentation. We did not use the product, purchase a plan, or run quality, speed or reliability tests in this review.

Consider it for

  • Teams able to manage PostgreSQL and evaluate approximate retrieval

Choose another approach if

  • A managed database or embedding service included automatically
  • Unmeasured guarantees of perfect approximate-search recall

Pricing and conditions

Documented terms

The extension licence permits use and distribution without a software fee. This is not a managed database quote: PostgreSQL compute, memory, storage, backups, operations and embedding/model services are separate. No universal hosting currency, tax, region, billing period or usage allowance was verified; obtain these from the chosen operator.

Pricing source read:

Pricing or terms source

Code, model and service licensing

The PostgreSQL-style licence permits any-purpose use, copying, modification and distribution without a written agreement or fee, while requiring the copyright, permission and disclaimer text in copies; it provides no warranty or maintenance obligation. It covers the extension, not every embedding model, dataset, hosted database or generated output. Your operator's data access, logs, backups, external embedding calls and training/retention terms need separate review; a local extension is not a blanket no-data-transfer promise.

Basis and limits of the recorded score

Original 4.6/5 retained; its original scoring worksheet and hands-on evidence are unavailable. This documentation review did not re-score it.

Overview

pgvector adds vector types, distance operators and nearest-neighbour search to PostgreSQL, so vector data can be queried and joined with relational rows. The documented extension supports exact search and optional HNSW or IVFFlat approximate indexes.

Approximate indexing changes search results and introduces recall, build-time and memory choices. Capacity also depends on PostgreSQL configuration, storage and workload; its published relation-size limit assumes a particular block size and is not a measured pgvector scaling result. Plan database operations and embedding generation separately, and measure retrieval quality on your own data.

Sources

The factual claims in this review were read from the pages below. Each date is when an editor last opened the source, not when the product changed.

Pros / Cons

Pros

  • Vector and relational queries in one PostgreSQL system
  • Permissive extension licence

Cons

  • Index configuration affects recall and resource use
  • You operate the database and embedding pipeline

Who it's for

01

Similarity search beside existing PostgreSQL records

02

RAG retrieval with separately licensed embeddings

Bottom line

Consider pgvector when PostgreSQL is a suitable operational base; validate indexing and costs rather than assuming the cheapest or most scalable architecture.

Key Features

Vector distances in PostgreSQL queries
HNSW and IVFFlat approximate indexes
Dense, half, binary and sparse vectors

Tags

PostgreSQL extensionVector retrievalSelf-hosting

Frequently asked questions

Is pgvector currently available?

No lifecycle review is recorded for this listing. Its inclusion in the directory does not confirm current availability; check the vendor before relying on it.

What is pgvector?

pgvector is a AI Platforms tool developed by pgvector community. A PostgreSQL extension for exact and approximate vector search alongside relational data, with HNSW and IVFFlat indexes.

What costs and terms should I check for pgvector?

The extension licence permits use and distribution without a software fee. This is not a managed database quote: PostgreSQL compute, memory, storage, backups, operations and embedding/model services are separate. No universal hosting currency, tax, region, billing period or usage allowance was verified; obtain these from the chosen operator.

Is pgvector open source?

The PostgreSQL-style licence permits any-purpose use, copying, modification and distribution without a written agreement or fee, while requiring the copyright, permission and disclaimer text in copies; it provides no warranty or maintenance obligation. It covers the extension, not every embedding model, dataset, hosted database or generated output. Your operator's data access, logs, backups, external embedding calls and training/retention terms need separate review; a local extension is not a blanket no-data-transfer promise.

What are the best alternatives to pgvector?

Notable AI Platforms alternatives include Hugging Face, Replicate, Ollama. Browse all 138 tools in our AI Platforms category for a full overview.

Was this listing useful?

Visit official website →

Basic Info

Pricing
Free

The extension licence permits use and distribution without a software fee. This is not a managed database quote: PostgreSQL compute, memory, storage, backups, operations and embedding/model services are separate. No universal hosting currency, tax, region, billing period or usage allowance was verified; obtain these from the chosen operator.

Editorial score
★ 4.6 / 5 How we score
Platforms
Postgres extensionLibrary
Last verified
Not recorded