vectorize

在PostgreSQL中封装RAG向量检索服务

概览

扩展包名版本分类许可证语言
pg_vectorize0.26.0RAGPostgreSQLRust
ID扩展名BinLibLoadCreateTrustReloc模式
1830vectorizevectorize
相关扩展pg_cron pgmq vector vchord vectorscale pg_summarize pg_tiktoken pg4ml pgml pg_later pg_similarity

版本

类型仓库版本PG 大版本包名依赖
EXTPIGSTY0.26.01817161514pg_vectorizepg_cron, pgmq, vector
RPMPIGSTY0.26.01817161514pg_vectorize_$vpgmq_$v, pg_cron_$v, pgvector_$v
DEBPIGSTY0.26.01817161514postgresql-$v-pg-vectorizepostgresql-$v-pgmq, postgresql-$v-pg-cron, postgresql-$v-pgvector
OS / PGPG18PG17PG16PG15PG14
el8.x86_64
el8.aarch64
el9.x86_64
el9.aarch64
el10.x86_64
el10.aarch64
d12.x86_64
PIGSTY 0.26.0
PIGSTY 0.26.0
PIGSTY 0.26.0
PIGSTY 0.26.0
PIGSTY 0.26.0
d12.aarch64
PIGSTY 0.26.0
PIGSTY 0.26.0
PIGSTY 0.26.0
PIGSTY 0.26.0
PIGSTY 0.26.0
d13.x86_64
PIGSTY 0.26.0
PIGSTY 0.26.0
PIGSTY 0.26.0
PIGSTY 0.26.0
PIGSTY 0.26.0
d13.aarch64
PIGSTY 0.26.0
PIGSTY 0.26.0
PIGSTY 0.26.0
PIGSTY 0.26.0
PIGSTY 0.26.0
u22.x86_64
PIGSTY 0.26.0
PIGSTY 0.26.0
PIGSTY 0.26.0
PIGSTY 0.26.0
PIGSTY 0.26.0
u22.aarch64
PIGSTY 0.26.0
PIGSTY 0.26.0
PIGSTY 0.26.0
PIGSTY 0.26.0
PIGSTY 0.26.0
u24.x86_64
PIGSTY 0.26.0
PIGSTY 0.26.0
PIGSTY 0.26.0
PIGSTY 0.26.0
PIGSTY 0.26.0
u24.aarch64
PIGSTY 0.26.0
PIGSTY 0.26.0
PIGSTY 0.26.0
PIGSTY 0.26.0
PIGSTY 0.26.0

构建

您可以使用 pig build 命令构建 pg_vectorize 扩展的 RPM / DEB 包:

pig build pkg pg_vectorize         # 构建 RPM / DEB 包

安装

您可以直接安装 pg_vectorize 扩展包的预置二进制包,首先确保 PGDGPIGSTY 仓库已经添加并启用:

pig repo add pgsql -u          # 添加仓库并更新缓存

使用 pig 或者是 apt/yum/dnf 安装扩展:

pig install pg_vectorize;          # 当前活跃 PG 版本安装
pig ext install -y pg_vectorize -v 18  # PG 18
pig ext install -y pg_vectorize -v 17  # PG 17
pig ext install -y pg_vectorize -v 16  # PG 16
pig ext install -y pg_vectorize -v 15  # PG 15
pig ext install -y pg_vectorize -v 14  # PG 14
dnf install -y pg_vectorize_18       # PG 18
dnf install -y pg_vectorize_17       # PG 17
dnf install -y pg_vectorize_16       # PG 16
dnf install -y pg_vectorize_15       # PG 15
dnf install -y pg_vectorize_14       # PG 14
apt install -y postgresql-18-pg-vectorize   # PG 18
apt install -y postgresql-17-pg-vectorize   # PG 17
apt install -y postgresql-16-pg-vectorize   # PG 16
apt install -y postgresql-15-pg-vectorize   # PG 15
apt install -y postgresql-14-pg-vectorize   # PG 14

创建扩展

CREATE EXTENSION vectorize CASCADE;  -- 依赖: pg_cron, pgmq, vector

最后修改 2026-03-08: add extension catalog (baacba6)