select open change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Extensions / AI and vectors

sparse_vector

C data type and functions for sparse float vectors, normalization, dot product, and cosine similarity.

pgext.cloud · Source code · Documentation · License text · Control file

Overview

Packagepg_sparse_vector
Version0.1
PostgreSQL versions10 · 11 · 12 · 13 · 14 · 15 · 16 · 17 · 18
RepositoryUnspecified
Extension typeStandard
Requires CREATE EXTENSIONYes
Requires preloadNo
TrustedNo
RelocatableNo
Stars2
Latest commit2021-01-04
Catalogue updated2026-08-30

Related extensions

See also

vectorvector data type and ivfflat and hnsw access methods
pgcontextVector, filter-aware HNSW, and hybrid retrieval over authoritative PostgreSQL tables.
smlarEffective similarity search
pg_similaritysupport similarity queries
vectorizeThe simplest way to do vector search on Postgres
embeddingHNSW vector similarity search extension for PostgreSQL real[] embeddings.
ruvectorSIMD-accelerated vector type and indexes with graph, solver, TDA, local embedding, and AI SQL functions.
pasePostgreSQL ultra-high dimensional approximate nearest neighbor search extension.
pg_bestmatchGenerate BM25 sparse vector inside PostgreSQL
pgmnemoSingle-plan multimodal agent memory for PostgreSQL