select open change scope Open full search

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

Extensions / AI and vectors

vector

vector data type and ivfflat and hnsw access methods

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

Overview

Packagepgvector
Version0.8.6
PostgreSQL versions14 · 15 · 16 · 17 · 18
RepositoryPGDG
Extension typeStandard
Requires CREATE EXTENSIONYes
Requires preloadNo
TrustedNo
RelocatableYes
Stars22,823
Latest commit2026-08-20
Latest release2026-07-29
Catalogue updated2026-08-30

Related extensions

Required by

aiHelper functions for AI workflows in PostgreSQL
aidbIn-database AI pipelines for chunking, embedding, retrieval, and generation.
alloydb_scannAlloyDB ScaNN extension for approximate nearest-neighbor vector indexes.
avocadoAvocadoDB PostgreSQL extension for deterministic context compilation for AI agents.
documentdbAPI surface for DocumentDB for PostgreSQL
embedding_searchLangChain/Supabase helper package for storing and searching document embeddings with pgvector.
hybrid_searchHybrid pgvector and full-text search helper functions for LangChain and Supabase.
maludb_coreA memory DBMS for long-term institutional memory, human-AI knowledge sharing, and contextual recall. PostgreSQL 17 extension.
pavesFiltered L2 vector search with CPU and optional GPU execution
pg_cuvs⚡ Blazing-fast GPU vector search for PostgreSQL powered by NVIDIA cuVS.
pg_diskannAzure Database for PostgreSQL extension for DiskANN approximate-nearest-neighbor vector indexes.
pg_gembedGenerate embeddings inside PostgreSQL
pg_knowledge_graphKnowledge graph extension for PostgreSQL with graph algorithms and pgvector integration.
pg_llmIntegrates local and remote large-language models with chat, sessions, text-to-SQL, audit and vector-backed knowledge features.
pg_llm_helperCaptures PostgreSQL errors in shared memory and exposes history plus an optional pgai-backed LLM troubleshooting function.
pg_sag_ragPure-SQL multi-hop event/entity retrieval, query routing, and in-database RAG evaluation.
pg_searchFull text search for PostgreSQL using BM25
pg_semantic_cacheCaches query results and retrieves semantically similar results using pgvector embeddings and configurable eviction policies.
pg_sentence_transformerRuns a Hugging Face sentence-transformer model inside a preload background worker and maintains pgvector embeddings for a configured table.
pg_spladeGenerate SPLADE sparse-vector embeddings inside PostgreSQL
pg_turboquantCompact TurboQuant approximate-nearest-neighbor index access method for pgvector vector and halfvec data.
pg_vector_embeddingTrigger-driven vector embedding through external HTTP services and a background queue.
pgcontext_pgvectorOptional pgvector compatibility bridge for pgcontext HNSW indexes.
pgedge_vectorizerAsynchronous text chunking and embedding generation for PostgreSQL using background workers and pgvector.
pgembedGenerate vector embeddings through Ollama, OpenAI, or custom HTTP services
pgmnemoSingle-plan multimodal agent memory for PostgreSQL
pgpuGPU acceleration for PostgreSQL vector index builds using NVIDIA CUDA/cuVS and VectorChord.
pgturbohybridhybrid vector and BM25 search for PostgreSQL on top of pgvector
pgvecutilsThis project is a PostgreSQL extension that provides vector manipulation utilities.
postvecAutomatic embeddings, hybrid search, and embedding model migration
ragDeprecated RAG helper extension for document extraction/chunking and remote embedding, reranking, and chat APIs.
rag_bge_small_en_v15rag_bge_small_en_v15: local bge-small-en-v1.5 embeddings in PostgreSQL
rag_jina_reranker_v1_tiny_enRuns jina-reranker-v1-tiny-en locally in a preloaded background worker and exposes SQL rerank scores and distances.
rds_aiAlibaba Cloud RDS extension for calling LLMs, generating embeddings, semantic retrieval, and end-to-end RAG from SQL
rds_embeddingAlibaba Cloud RDS text-to-vector model invocation extension
svsSVS Vamana approximate-nearest-neighbor index with LeanVec and LVQ compression for pgvector.
vchordVector database plugin for Postgres, written in Rust
vectorizeThe simplest way to do vector search on Postgres
vectorscaleAdvanced indexing for vector data with DiskANN

See also

vchordVector database plugin for Postgres, written in Rust
vectorscaleAdvanced indexing for vector data with DiskANN
pgcontextVector, filter-aware HNSW, and hybrid retrieval over authoritative PostgreSQL tables.
vectorizeThe simplest way to do vector search on Postgres
pg_rrfReciprocal rank fusion functions for hybrid search
pg_searchFull text search for PostgreSQL using BM25
vchord_bm25A postgresql extension for bm25 ranking algorithm
pg_bestmatchGenerate BM25 sparse vector inside PostgreSQL
pgmlRun AL/ML workloads with SQL interface
pg4mlMachine learning framework for PostgreSQL

Same project

pgvectorCustom vector type with Euclidean distance, cosine similarity, and prototype IVFFlat helpers.