vectorscale

使用DiskANN算法对向量进行高效索引

概览

扩展包名	版本	分类	许可证	语言
`pgvectorscale`	`0.9.0`	RAG	PostgreSQL	Rust

ID	扩展名	Bin	Lib	Load	Create	Trust	Reloc	模式
1820	`vectorscale`	否	是	否	是	否	否	-

相关扩展	`vector` `vector` `vchord` `pgcontext` `vectorize` `pg_rrf` `pg_search` `vchord_bm25` `pg_bestmatch` `pgml` `pg4ml`

版本

类型	仓库	版本	PG 大版本	包名	依赖
EXT	PIGSTY	`0.9.0`	1817161514	`pgvectorscale`	`vector`
RPM	PIGSTY	`0.9.0`	1817161514	`pgvectorscale_$v`	`pgvector_$v`
DEB	PIGSTY	`0.9.0`	1817161514	`postgresql-$v-pgvectorscale`	`postgresql-$v-pgvector`

OS / PG	PG18	PG17	PG16	PG15	PG14
el8.x86_64	PIGSTY 0.9.0 el8.x86_64.pg18 : pgvectorscale_18 pgvectorscale_18-0.9.0-3PIGSTY.el8.x86_64.rpm PIGSTY · 0.9.0 · 1.1MiB	PIGSTY 0.9.0 el8.x86_64.pg17 : pgvectorscale_17 pgvectorscale_17-0.9.0-3PIGSTY.el8.x86_64.rpm PIGSTY · 0.9.0 · 1.1MiB	PIGSTY 0.9.0 el8.x86_64.pg16 : pgvectorscale_16 pgvectorscale_16-0.9.0-3PIGSTY.el8.x86_64.rpm PIGSTY · 0.9.0 · 1.1MiB	PIGSTY 0.9.0 el8.x86_64.pg15 : pgvectorscale_15 pgvectorscale_15-0.9.0-3PIGSTY.el8.x86_64.rpm PIGSTY · 0.9.0 · 1.1MiB	PIGSTY 0.9.0 el8.x86_64.pg14 : pgvectorscale_14 pgvectorscale_14-0.9.0-3PIGSTY.el8.x86_64.rpm PIGSTY · 0.9.0 · 1.1MiB
el8.aarch64	PIGSTY 0.9.0 el8.aarch64.pg18 : pgvectorscale_18 pgvectorscale_18-0.9.0-3PIGSTY.el8.aarch64.rpm PIGSTY · 0.9.0 · 977.8KiB	PIGSTY 0.9.0 el8.aarch64.pg17 : pgvectorscale_17 pgvectorscale_17-0.9.0-3PIGSTY.el8.aarch64.rpm PIGSTY · 0.9.0 · 974.7KiB	PIGSTY 0.9.0 el8.aarch64.pg16 : pgvectorscale_16 pgvectorscale_16-0.9.0-3PIGSTY.el8.aarch64.rpm PIGSTY · 0.9.0 · 973.2KiB	PIGSTY 0.9.0 el8.aarch64.pg15 : pgvectorscale_15 pgvectorscale_15-0.9.0-3PIGSTY.el8.aarch64.rpm PIGSTY · 0.9.0 · 963.6KiB	PIGSTY 0.9.0 el8.aarch64.pg14 : pgvectorscale_14 pgvectorscale_14-0.9.0-3PIGSTY.el8.aarch64.rpm PIGSTY · 0.9.0 · 960.4KiB
el9.x86_64	PIGSTY 0.9.0 el9.x86_64.pg18 : pgvectorscale_18 pgvectorscale_18-0.9.0-3PIGSTY.el9.x86_64.rpm PIGSTY · 0.9.0 · 1.1MiB	PIGSTY 0.9.0 el9.x86_64.pg17 : pgvectorscale_17 pgvectorscale_17-0.9.0-3PIGSTY.el9.x86_64.rpm PIGSTY · 0.9.0 · 1.1MiB	PIGSTY 0.9.0 el9.x86_64.pg16 : pgvectorscale_16 pgvectorscale_16-0.9.0-3PIGSTY.el9.x86_64.rpm PIGSTY · 0.9.0 · 1.1MiB	PIGSTY 0.9.0 el9.x86_64.pg15 : pgvectorscale_15 pgvectorscale_15-0.9.0-3PIGSTY.el9.x86_64.rpm PIGSTY · 0.9.0 · 1.1MiB	PIGSTY 0.9.0 el9.x86_64.pg14 : pgvectorscale_14 pgvectorscale_14-0.9.0-3PIGSTY.el9.x86_64.rpm PIGSTY · 0.9.0 · 1.1MiB
el9.aarch64	PIGSTY 0.9.0 el9.aarch64.pg18 : pgvectorscale_18 pgvectorscale_18-0.9.0-3PIGSTY.el9.aarch64.rpm PIGSTY · 0.9.0 · 1.0MiB	PIGSTY 0.9.0 el9.aarch64.pg17 : pgvectorscale_17 pgvectorscale_17-0.9.0-3PIGSTY.el9.aarch64.rpm PIGSTY · 0.9.0 · 1.0MiB	PIGSTY 0.9.0 el9.aarch64.pg16 : pgvectorscale_16 pgvectorscale_16-0.9.0-3PIGSTY.el9.aarch64.rpm PIGSTY · 0.9.0 · 1.0MiB	PIGSTY 0.9.0 el9.aarch64.pg15 : pgvectorscale_15 pgvectorscale_15-0.9.0-3PIGSTY.el9.aarch64.rpm PIGSTY · 0.9.0 · 1.0MiB	PIGSTY 0.9.0 el9.aarch64.pg14 : pgvectorscale_14 pgvectorscale_14-0.9.0-3PIGSTY.el9.aarch64.rpm PIGSTY · 0.9.0 · 1020.6KiB
el10.x86_64	PIGSTY 0.9.0 el10.x86_64.pg18 : pgvectorscale_18 pgvectorscale_18-0.9.0-3PIGSTY.el10.x86_64.rpm PIGSTY · 0.9.0 · 1.1MiB	PIGSTY 0.9.0 el10.x86_64.pg17 : pgvectorscale_17 pgvectorscale_17-0.9.0-3PIGSTY.el10.x86_64.rpm PIGSTY · 0.9.0 · 1.1MiB	PIGSTY 0.9.0 el10.x86_64.pg16 : pgvectorscale_16 pgvectorscale_16-0.9.0-3PIGSTY.el10.x86_64.rpm PIGSTY · 0.9.0 · 1.1MiB	PIGSTY 0.9.0 el10.x86_64.pg15 : pgvectorscale_15 pgvectorscale_15-0.9.0-3PIGSTY.el10.x86_64.rpm PIGSTY · 0.9.0 · 1.1MiB	PIGSTY 0.9.0 el10.x86_64.pg14 : pgvectorscale_14 pgvectorscale_14-0.9.0-3PIGSTY.el10.x86_64.rpm PIGSTY · 0.9.0 · 1.1MiB
el10.aarch64	PIGSTY 0.9.0 el10.aarch64.pg18 : pgvectorscale_18 pgvectorscale_18-0.9.0-3PIGSTY.el10.aarch64.rpm PIGSTY · 0.9.0 · 1018.5KiB	PIGSTY 0.9.0 el10.aarch64.pg17 : pgvectorscale_17 pgvectorscale_17-0.9.0-3PIGSTY.el10.aarch64.rpm PIGSTY · 0.9.0 · 1016.4KiB	PIGSTY 0.9.0 el10.aarch64.pg16 : pgvectorscale_16 pgvectorscale_16-0.9.0-3PIGSTY.el10.aarch64.rpm PIGSTY · 0.9.0 · 1016.7KiB	PIGSTY 0.9.0 el10.aarch64.pg15 : pgvectorscale_15 pgvectorscale_15-0.9.0-3PIGSTY.el10.aarch64.rpm PIGSTY · 0.9.0 · 1012.6KiB	PIGSTY 0.9.0 el10.aarch64.pg14 : pgvectorscale_14 pgvectorscale_14-0.9.0-3PIGSTY.el10.aarch64.rpm PIGSTY · 0.9.0 · 1009.2KiB
d12.x86_64	PIGSTY 0.9.0 d12.x86_64.pg18 : postgresql-18-pgvectorscale postgresql-18-pgvectorscale_0.9.0-3PIGSTY~bookworm_amd64.deb PIGSTY · 0.9.0 · 888.7KiB	PIGSTY 0.9.0 d12.x86_64.pg17 : postgresql-17-pgvectorscale postgresql-17-pgvectorscale_0.9.0-3PIGSTY~bookworm_amd64.deb PIGSTY · 0.9.0 · 887.0KiB	PIGSTY 0.9.0 d12.x86_64.pg16 : postgresql-16-pgvectorscale postgresql-16-pgvectorscale_0.9.0-3PIGSTY~bookworm_amd64.deb PIGSTY · 0.9.0 · 886.8KiB	PIGSTY 0.9.0 d12.x86_64.pg15 : postgresql-15-pgvectorscale postgresql-15-pgvectorscale_0.9.0-3PIGSTY~bookworm_amd64.deb PIGSTY · 0.9.0 · 879.9KiB	PIGSTY 0.9.0 d12.x86_64.pg14 : postgresql-14-pgvectorscale postgresql-14-pgvectorscale_0.9.0-3PIGSTY~bookworm_amd64.deb PIGSTY · 0.9.0 · 876.1KiB
d12.aarch64	PIGSTY 0.9.0 d12.aarch64.pg18 : postgresql-18-pgvectorscale postgresql-18-pgvectorscale_0.9.0-3PIGSTY~bookworm_arm64.deb PIGSTY · 0.9.0 · 731.8KiB	PIGSTY 0.9.0 d12.aarch64.pg17 : postgresql-17-pgvectorscale postgresql-17-pgvectorscale_0.9.0-3PIGSTY~bookworm_arm64.deb PIGSTY · 0.9.0 · 731.4KiB	PIGSTY 0.9.0 d12.aarch64.pg16 : postgresql-16-pgvectorscale postgresql-16-pgvectorscale_0.9.0-3PIGSTY~bookworm_arm64.deb PIGSTY · 0.9.0 · 731.6KiB	PIGSTY 0.9.0 d12.aarch64.pg15 : postgresql-15-pgvectorscale postgresql-15-pgvectorscale_0.9.0-3PIGSTY~bookworm_arm64.deb PIGSTY · 0.9.0 · 726.2KiB	PIGSTY 0.9.0 d12.aarch64.pg14 : postgresql-14-pgvectorscale postgresql-14-pgvectorscale_0.9.0-3PIGSTY~bookworm_arm64.deb PIGSTY · 0.9.0 · 723.6KiB
d13.x86_64	PIGSTY 0.9.0 d13.x86_64.pg18 : postgresql-18-pgvectorscale postgresql-18-pgvectorscale_0.9.0-3PIGSTY~trixie_amd64.deb PIGSTY · 0.9.0 · 889.0KiB	PIGSTY 0.9.0 d13.x86_64.pg17 : postgresql-17-pgvectorscale postgresql-17-pgvectorscale_0.9.0-3PIGSTY~trixie_amd64.deb PIGSTY · 0.9.0 · 886.8KiB	PIGSTY 0.9.0 d13.x86_64.pg16 : postgresql-16-pgvectorscale postgresql-16-pgvectorscale_0.9.0-3PIGSTY~trixie_amd64.deb PIGSTY · 0.9.0 · 886.5KiB	PIGSTY 0.9.0 d13.x86_64.pg15 : postgresql-15-pgvectorscale postgresql-15-pgvectorscale_0.9.0-3PIGSTY~trixie_amd64.deb PIGSTY · 0.9.0 · 879.2KiB	PIGSTY 0.9.0 d13.x86_64.pg14 : postgresql-14-pgvectorscale postgresql-14-pgvectorscale_0.9.0-3PIGSTY~trixie_amd64.deb PIGSTY · 0.9.0 · 876.8KiB
d13.aarch64	PIGSTY 0.9.0 d13.aarch64.pg18 : postgresql-18-pgvectorscale postgresql-18-pgvectorscale_0.9.0-3PIGSTY~trixie_arm64.deb PIGSTY · 0.9.0 · 733.5KiB	PIGSTY 0.9.0 d13.aarch64.pg17 : postgresql-17-pgvectorscale postgresql-17-pgvectorscale_0.9.0-3PIGSTY~trixie_arm64.deb PIGSTY · 0.9.0 · 731.7KiB	PIGSTY 0.9.0 d13.aarch64.pg16 : postgresql-16-pgvectorscale postgresql-16-pgvectorscale_0.9.0-3PIGSTY~trixie_arm64.deb PIGSTY · 0.9.0 · 731.9KiB	PIGSTY 0.9.0 d13.aarch64.pg15 : postgresql-15-pgvectorscale postgresql-15-pgvectorscale_0.9.0-3PIGSTY~trixie_arm64.deb PIGSTY · 0.9.0 · 727.0KiB	PIGSTY 0.9.0 d13.aarch64.pg14 : postgresql-14-pgvectorscale postgresql-14-pgvectorscale_0.9.0-3PIGSTY~trixie_arm64.deb PIGSTY · 0.9.0 · 723.4KiB
u22.x86_64	PIGSTY 0.9.0 u22.x86_64.pg18 : postgresql-18-pgvectorscale postgresql-18-pgvectorscale_0.9.0-3PIGSTY~jammy_amd64.deb PIGSTY · 0.9.0 · 987.5KiB	PIGSTY 0.9.0 u22.x86_64.pg17 : postgresql-17-pgvectorscale postgresql-17-pgvectorscale_0.9.0-3PIGSTY~jammy_amd64.deb PIGSTY · 0.9.0 · 984.9KiB	PIGSTY 0.9.0 u22.x86_64.pg16 : postgresql-16-pgvectorscale postgresql-16-pgvectorscale_0.9.0-3PIGSTY~jammy_amd64.deb PIGSTY · 0.9.0 · 985.1KiB	PIGSTY 0.9.0 u22.x86_64.pg15 : postgresql-15-pgvectorscale postgresql-15-pgvectorscale_0.9.0-3PIGSTY~jammy_amd64.deb PIGSTY · 0.9.0 · 975.4KiB	PIGSTY 0.9.0 u22.x86_64.pg14 : postgresql-14-pgvectorscale postgresql-14-pgvectorscale_0.9.0-3PIGSTY~jammy_amd64.deb PIGSTY · 0.9.0 · 970.8KiB
u22.aarch64	PIGSTY 0.9.0 u22.aarch64.pg18 : postgresql-18-pgvectorscale postgresql-18-pgvectorscale_0.9.0-3PIGSTY~jammy_arm64.deb PIGSTY · 0.9.0 · 867.4KiB	PIGSTY 0.9.0 u22.aarch64.pg17 : postgresql-17-pgvectorscale postgresql-17-pgvectorscale_0.9.0-3PIGSTY~jammy_arm64.deb PIGSTY · 0.9.0 · 865.5KiB	PIGSTY 0.9.0 u22.aarch64.pg16 : postgresql-16-pgvectorscale postgresql-16-pgvectorscale_0.9.0-3PIGSTY~jammy_arm64.deb PIGSTY · 0.9.0 · 864.9KiB	PIGSTY 0.9.0 u22.aarch64.pg15 : postgresql-15-pgvectorscale postgresql-15-pgvectorscale_0.9.0-3PIGSTY~jammy_arm64.deb PIGSTY · 0.9.0 · 857.7KiB	PIGSTY 0.9.0 u22.aarch64.pg14 : postgresql-14-pgvectorscale postgresql-14-pgvectorscale_0.9.0-3PIGSTY~jammy_arm64.deb PIGSTY · 0.9.0 · 854.3KiB
u24.x86_64	PIGSTY 0.9.0 u24.x86_64.pg18 : postgresql-18-pgvectorscale postgresql-18-pgvectorscale_0.9.0-3PIGSTY~noble_amd64.deb PIGSTY · 0.9.0 · 976.6KiB	PIGSTY 0.9.0 u24.x86_64.pg17 : postgresql-17-pgvectorscale postgresql-17-pgvectorscale_0.9.0-3PIGSTY~noble_amd64.deb PIGSTY · 0.9.0 · 973.2KiB	PIGSTY 0.9.0 u24.x86_64.pg16 : postgresql-16-pgvectorscale postgresql-16-pgvectorscale_0.9.0-3PIGSTY~noble_amd64.deb PIGSTY · 0.9.0 · 975.1KiB	PIGSTY 0.9.0 u24.x86_64.pg15 : postgresql-15-pgvectorscale postgresql-15-pgvectorscale_0.9.0-3PIGSTY~noble_amd64.deb PIGSTY · 0.9.0 · 966.1KiB	PIGSTY 0.9.0 u24.x86_64.pg14 : postgresql-14-pgvectorscale postgresql-14-pgvectorscale_0.9.0-3PIGSTY~noble_amd64.deb PIGSTY · 0.9.0 · 960.7KiB
u24.aarch64	PIGSTY 0.9.0 u24.aarch64.pg18 : postgresql-18-pgvectorscale postgresql-18-pgvectorscale_0.9.0-3PIGSTY~noble_arm64.deb PIGSTY · 0.9.0 · 856.8KiB	PIGSTY 0.9.0 u24.aarch64.pg17 : postgresql-17-pgvectorscale postgresql-17-pgvectorscale_0.9.0-3PIGSTY~noble_arm64.deb PIGSTY · 0.9.0 · 854.4KiB	PIGSTY 0.9.0 u24.aarch64.pg16 : postgresql-16-pgvectorscale postgresql-16-pgvectorscale_0.9.0-3PIGSTY~noble_arm64.deb PIGSTY · 0.9.0 · 854.6KiB	PIGSTY 0.9.0 u24.aarch64.pg15 : postgresql-15-pgvectorscale postgresql-15-pgvectorscale_0.9.0-3PIGSTY~noble_arm64.deb PIGSTY · 0.9.0 · 849.4KiB	PIGSTY 0.9.0 u24.aarch64.pg14 : postgresql-14-pgvectorscale postgresql-14-pgvectorscale_0.9.0-3PIGSTY~noble_arm64.deb PIGSTY · 0.9.0 · 845.1KiB
u26.x86_64	PIGSTY 0.9.0 u26.x86_64.pg18 : postgresql-18-pgvectorscale postgresql-18-pgvectorscale_0.9.0-3PIGSTY~resolute_amd64.deb PIGSTY · 0.9.0 · 973.2KiB	PIGSTY 0.9.0 u26.x86_64.pg17 : postgresql-17-pgvectorscale postgresql-17-pgvectorscale_0.9.0-3PIGSTY~resolute_amd64.deb PIGSTY · 0.9.0 · 969.8KiB	PIGSTY 0.9.0 u26.x86_64.pg16 : postgresql-16-pgvectorscale postgresql-16-pgvectorscale_0.9.0-3PIGSTY~resolute_amd64.deb PIGSTY · 0.9.0 · 968.7KiB	PIGSTY 0.9.0 u26.x86_64.pg15 : postgresql-15-pgvectorscale postgresql-15-pgvectorscale_0.9.0-3PIGSTY~resolute_amd64.deb PIGSTY · 0.9.0 · 962.9KiB	PIGSTY 0.9.0 u26.x86_64.pg14 : postgresql-14-pgvectorscale postgresql-14-pgvectorscale_0.9.0-3PIGSTY~resolute_amd64.deb PIGSTY · 0.9.0 · 958.6KiB
u26.aarch64	PIGSTY 0.9.0 u26.aarch64.pg18 : postgresql-18-pgvectorscale postgresql-18-pgvectorscale_0.9.0-3PIGSTY~resolute_arm64.deb PIGSTY · 0.9.0 · 855.8KiB	PIGSTY 0.9.0 u26.aarch64.pg17 : postgresql-17-pgvectorscale postgresql-17-pgvectorscale_0.9.0-3PIGSTY~resolute_arm64.deb PIGSTY · 0.9.0 · 853.1KiB	PIGSTY 0.9.0 u26.aarch64.pg16 : postgresql-16-pgvectorscale postgresql-16-pgvectorscale_0.9.0-3PIGSTY~resolute_arm64.deb PIGSTY · 0.9.0 · 853.5KiB	PIGSTY 0.9.0 u26.aarch64.pg15 : postgresql-15-pgvectorscale postgresql-15-pgvectorscale_0.9.0-3PIGSTY~resolute_arm64.deb PIGSTY · 0.9.0 · 846.2KiB	PIGSTY 0.9.0 u26.aarch64.pg14 : postgresql-14-pgvectorscale postgresql-14-pgvectorscale_0.9.0-3PIGSTY~resolute_arm64.deb PIGSTY · 0.9.0 · 842.6KiB

构建

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

BASH

pig build pkg pgvectorscale         # 构建 RPM / DEB 包

安装

您可以直接安装 pgvectorscale 扩展包的预置二进制包，首先确保 PGDG 和 PIGSTY 仓库已经添加并启用：

BASH

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

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

安装

BASH

pig install pgvectorscale;          # 当前活跃 PG 版本安装

pig

BASH

pig ext install -y pgvectorscale -v 18  # PG 18
pig ext install -y pgvectorscale -v 17  # PG 17
pig ext install -y pgvectorscale -v 16  # PG 16
pig ext install -y pgvectorscale -v 15  # PG 15
pig ext install -y pgvectorscale -v 14  # PG 14

dnf

BASH

dnf install -y pgvectorscale_18       # PG 18
dnf install -y pgvectorscale_17       # PG 17
dnf install -y pgvectorscale_16       # PG 16
dnf install -y pgvectorscale_15       # PG 15
dnf install -y pgvectorscale_14       # PG 14

apt

BASH

apt install -y postgresql-18-pgvectorscale   # PG 18
apt install -y postgresql-17-pgvectorscale   # PG 17
apt install -y postgresql-16-pgvectorscale   # PG 16
apt install -y postgresql-15-pgvectorscale   # PG 15
apt install -y postgresql-14-pgvectorscale   # PG 14

创建扩展：

SQL

CREATE EXTENSION vectorscale CASCADE;  -- 依赖: vector

用法

vectorscale 使用 StreamingDiskANN 索引访问方法扩展 pgvector，用于近似最近邻搜索。下面的示例会创建向量表、构建 diskann 索引，并按向量距离执行排序查询。

SQL

CREATE EXTENSION vectorscale CASCADE;

CREATE TABLE IF NOT EXISTS document_embedding  (
    id BIGINT PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY,
    metadata JSONB,
    contents TEXT,
    embedding VECTOR(1536)
);

-- 使用 diskann 索引方法创建向量索引
CREATE INDEX document_embedding_idx ON document_embedding
USING diskann (embedding);

-- 基于向量距离进行近似最近邻查询
SELECT *
FROM document_embedding
ORDER BY embedding <=> $1
LIMIT 10

意见反馈

这个页面对您有帮助吗？

感谢反馈！请告诉我们如何改进。

抱歉给您带来不便。请告诉我们如何改进。