pg_rrf

混合检索的倒数排序融合函数

概览

扩展包名	版本	分类	许可证	语言
`pg_rrf`	`0.0.3`	RAG	MIT	Rust

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

相关扩展	`pg_search` `pg_bestmatch` `vector` `pgcontext` `vectorize` `pg_textsearch` `vchord_bm25` `pg_fts` `pgmnemo` `pg_similarity`

版本

类型	仓库	版本	PG 大版本	包名	依赖
EXT	PIGSTY	`0.0.3`	1817161514	`pg_rrf`	-
RPM	PIGSTY	`0.0.3`	1817161514	`pg_rrf_$v`	-
DEB	PIGSTY	`0.0.3`	1817161514	`postgresql-$v-pg-rrf`	-

OS / PG	PG18	PG17	PG16	PG15	PG14
el8.x86_64	PIGSTY 0.0.3 el8.x86_64.pg18 : pg_rrf_18 pg_rrf_18-0.0.3-3PIGSTY.el8.x86_64.rpm PIGSTY · 0.0.3 · 856.7KiB	PIGSTY 0.0.3 el8.x86_64.pg17 : pg_rrf_17 pg_rrf_17-0.0.3-3PIGSTY.el8.x86_64.rpm PIGSTY · 0.0.3 · 854.1KiB	PIGSTY 0.0.3 el8.x86_64.pg16 : pg_rrf_16 pg_rrf_16-0.0.3-3PIGSTY.el8.x86_64.rpm PIGSTY · 0.0.3 · 853.2KiB	PIGSTY 0.0.3 el8.x86_64.pg15 : pg_rrf_15 pg_rrf_15-0.0.3-3PIGSTY.el8.x86_64.rpm PIGSTY · 0.0.3 · 842.9KiB	PIGSTY 0.0.3 el8.x86_64.pg14 : pg_rrf_14 pg_rrf_14-0.0.3-3PIGSTY.el8.x86_64.rpm PIGSTY · 0.0.3 · 840.8KiB
el8.aarch64	PIGSTY 0.0.3 el8.aarch64.pg18 : pg_rrf_18 pg_rrf_18-0.0.3-3PIGSTY.el8.aarch64.rpm PIGSTY · 0.0.3 · 769.0KiB	PIGSTY 0.0.3 el8.aarch64.pg17 : pg_rrf_17 pg_rrf_17-0.0.3-3PIGSTY.el8.aarch64.rpm PIGSTY · 0.0.3 · 765.9KiB	PIGSTY 0.0.3 el8.aarch64.pg16 : pg_rrf_16 pg_rrf_16-0.0.3-3PIGSTY.el8.aarch64.rpm PIGSTY · 0.0.3 · 764.4KiB	PIGSTY 0.0.3 el8.aarch64.pg15 : pg_rrf_15 pg_rrf_15-0.0.3-3PIGSTY.el8.aarch64.rpm PIGSTY · 0.0.3 · 755.1KiB	PIGSTY 0.0.3 el8.aarch64.pg14 : pg_rrf_14 pg_rrf_14-0.0.3-3PIGSTY.el8.aarch64.rpm PIGSTY · 0.0.3 · 753.3KiB
el9.x86_64	PIGSTY 0.0.3 el9.x86_64.pg18 : pg_rrf_18 pg_rrf_18-0.0.3-3PIGSTY.el9.x86_64.rpm PIGSTY · 0.0.3 · 867.4KiB	PIGSTY 0.0.3 el9.x86_64.pg17 : pg_rrf_17 pg_rrf_17-0.0.3-3PIGSTY.el9.x86_64.rpm PIGSTY · 0.0.3 · 863.8KiB	PIGSTY 0.0.3 el9.x86_64.pg16 : pg_rrf_16 pg_rrf_16-0.0.3-3PIGSTY.el9.x86_64.rpm PIGSTY · 0.0.3 · 862.1KiB	PIGSTY 0.0.3 el9.x86_64.pg15 : pg_rrf_15 pg_rrf_15-0.0.3-3PIGSTY.el9.x86_64.rpm PIGSTY · 0.0.3 · 852.2KiB	PIGSTY 0.0.3 el9.x86_64.pg14 : pg_rrf_14 pg_rrf_14-0.0.3-3PIGSTY.el9.x86_64.rpm PIGSTY · 0.0.3 · 849.4KiB
el9.aarch64	PIGSTY 0.0.3 el9.aarch64.pg18 : pg_rrf_18 pg_rrf_18-0.0.3-3PIGSTY.el9.aarch64.rpm PIGSTY · 0.0.3 · 815.4KiB	PIGSTY 0.0.3 el9.aarch64.pg17 : pg_rrf_17 pg_rrf_17-0.0.3-3PIGSTY.el9.aarch64.rpm PIGSTY · 0.0.3 · 811.8KiB	PIGSTY 0.0.3 el9.aarch64.pg16 : pg_rrf_16 pg_rrf_16-0.0.3-3PIGSTY.el9.aarch64.rpm PIGSTY · 0.0.3 · 810.3KiB	PIGSTY 0.0.3 el9.aarch64.pg15 : pg_rrf_15 pg_rrf_15-0.0.3-3PIGSTY.el9.aarch64.rpm PIGSTY · 0.0.3 · 800.6KiB	PIGSTY 0.0.3 el9.aarch64.pg14 : pg_rrf_14 pg_rrf_14-0.0.3-3PIGSTY.el9.aarch64.rpm PIGSTY · 0.0.3 · 798.2KiB
el10.x86_64	PIGSTY 0.0.3 el10.x86_64.pg18 : pg_rrf_18 pg_rrf_18-0.0.3-3PIGSTY.el10.x86_64.rpm PIGSTY · 0.0.3 · 867.2KiB	PIGSTY 0.0.3 el10.x86_64.pg17 : pg_rrf_17 pg_rrf_17-0.0.3-3PIGSTY.el10.x86_64.rpm PIGSTY · 0.0.3 · 863.6KiB	PIGSTY 0.0.3 el10.x86_64.pg16 : pg_rrf_16 pg_rrf_16-0.0.3-3PIGSTY.el10.x86_64.rpm PIGSTY · 0.0.3 · 863.3KiB	PIGSTY 0.0.3 el10.x86_64.pg15 : pg_rrf_15 pg_rrf_15-0.0.3-3PIGSTY.el10.x86_64.rpm PIGSTY · 0.0.3 · 852.5KiB	PIGSTY 0.0.3 el10.x86_64.pg14 : pg_rrf_14 pg_rrf_14-0.0.3-3PIGSTY.el10.x86_64.rpm PIGSTY · 0.0.3 · 849.2KiB
el10.aarch64	PIGSTY 0.0.3 el10.aarch64.pg18 : pg_rrf_18 pg_rrf_18-0.0.3-3PIGSTY.el10.aarch64.rpm PIGSTY · 0.0.3 · 794.1KiB	PIGSTY 0.0.3 el10.aarch64.pg17 : pg_rrf_17 pg_rrf_17-0.0.3-3PIGSTY.el10.aarch64.rpm PIGSTY · 0.0.3 · 793.3KiB	PIGSTY 0.0.3 el10.aarch64.pg16 : pg_rrf_16 pg_rrf_16-0.0.3-3PIGSTY.el10.aarch64.rpm PIGSTY · 0.0.3 · 792.7KiB	PIGSTY 0.0.3 el10.aarch64.pg15 : pg_rrf_15 pg_rrf_15-0.0.3-3PIGSTY.el10.aarch64.rpm PIGSTY · 0.0.3 · 787.9KiB	PIGSTY 0.0.3 el10.aarch64.pg14 : pg_rrf_14 pg_rrf_14-0.0.3-3PIGSTY.el10.aarch64.rpm PIGSTY · 0.0.3 · 785.5KiB
d12.x86_64	PIGSTY 0.0.3 d12.x86_64.pg18 : postgresql-18-pg-rrf postgresql-18-pg-rrf_0.0.3-3PIGSTY~bookworm_amd64.deb PIGSTY · 0.0.3 · 682.5KiB	PIGSTY 0.0.3 d12.x86_64.pg17 : postgresql-17-pg-rrf postgresql-17-pg-rrf_0.0.3-3PIGSTY~bookworm_amd64.deb PIGSTY · 0.0.3 · 681.5KiB	PIGSTY 0.0.3 d12.x86_64.pg16 : postgresql-16-pg-rrf postgresql-16-pg-rrf_0.0.3-3PIGSTY~bookworm_amd64.deb PIGSTY · 0.0.3 · 680.9KiB	PIGSTY 0.0.3 d12.x86_64.pg15 : postgresql-15-pg-rrf postgresql-15-pg-rrf_0.0.3-3PIGSTY~bookworm_amd64.deb PIGSTY · 0.0.3 · 673.9KiB	PIGSTY 0.0.3 d12.x86_64.pg14 : postgresql-14-pg-rrf postgresql-14-pg-rrf_0.0.3-3PIGSTY~bookworm_amd64.deb PIGSTY · 0.0.3 · 672.1KiB
d12.aarch64	PIGSTY 0.0.3 d12.aarch64.pg18 : postgresql-18-pg-rrf postgresql-18-pg-rrf_0.0.3-3PIGSTY~bookworm_arm64.deb PIGSTY · 0.0.3 · 569.4KiB	PIGSTY 0.0.3 d12.aarch64.pg17 : postgresql-17-pg-rrf postgresql-17-pg-rrf_0.0.3-3PIGSTY~bookworm_arm64.deb PIGSTY · 0.0.3 · 567.3KiB	PIGSTY 0.0.3 d12.aarch64.pg16 : postgresql-16-pg-rrf postgresql-16-pg-rrf_0.0.3-3PIGSTY~bookworm_arm64.deb PIGSTY · 0.0.3 · 566.7KiB	PIGSTY 0.0.3 d12.aarch64.pg15 : postgresql-15-pg-rrf postgresql-15-pg-rrf_0.0.3-3PIGSTY~bookworm_arm64.deb PIGSTY · 0.0.3 · 561.9KiB	PIGSTY 0.0.3 d12.aarch64.pg14 : postgresql-14-pg-rrf postgresql-14-pg-rrf_0.0.3-3PIGSTY~bookworm_arm64.deb PIGSTY · 0.0.3 · 560.5KiB
d13.x86_64	PIGSTY 0.0.3 d13.x86_64.pg18 : postgresql-18-pg-rrf postgresql-18-pg-rrf_0.0.3-3PIGSTY~trixie_amd64.deb PIGSTY · 0.0.3 · 682.9KiB	PIGSTY 0.0.3 d13.x86_64.pg17 : postgresql-17-pg-rrf postgresql-17-pg-rrf_0.0.3-3PIGSTY~trixie_amd64.deb PIGSTY · 0.0.3 · 680.8KiB	PIGSTY 0.0.3 d13.x86_64.pg16 : postgresql-16-pg-rrf postgresql-16-pg-rrf_0.0.3-3PIGSTY~trixie_amd64.deb PIGSTY · 0.0.3 · 681.3KiB	PIGSTY 0.0.3 d13.x86_64.pg15 : postgresql-15-pg-rrf postgresql-15-pg-rrf_0.0.3-3PIGSTY~trixie_amd64.deb PIGSTY · 0.0.3 · 673.9KiB	PIGSTY 0.0.3 d13.x86_64.pg14 : postgresql-14-pg-rrf postgresql-14-pg-rrf_0.0.3-3PIGSTY~trixie_amd64.deb PIGSTY · 0.0.3 · 671.9KiB
d13.aarch64	PIGSTY 0.0.3 d13.aarch64.pg18 : postgresql-18-pg-rrf postgresql-18-pg-rrf_0.0.3-3PIGSTY~trixie_arm64.deb PIGSTY · 0.0.3 · 569.2KiB	PIGSTY 0.0.3 d13.aarch64.pg17 : postgresql-17-pg-rrf postgresql-17-pg-rrf_0.0.3-3PIGSTY~trixie_arm64.deb PIGSTY · 0.0.3 · 568.1KiB	PIGSTY 0.0.3 d13.aarch64.pg16 : postgresql-16-pg-rrf postgresql-16-pg-rrf_0.0.3-3PIGSTY~trixie_arm64.deb PIGSTY · 0.0.3 · 567.0KiB	PIGSTY 0.0.3 d13.aarch64.pg15 : postgresql-15-pg-rrf postgresql-15-pg-rrf_0.0.3-3PIGSTY~trixie_arm64.deb PIGSTY · 0.0.3 · 562.3KiB	PIGSTY 0.0.3 d13.aarch64.pg14 : postgresql-14-pg-rrf postgresql-14-pg-rrf_0.0.3-3PIGSTY~trixie_arm64.deb PIGSTY · 0.0.3 · 560.8KiB
u22.x86_64	PIGSTY 0.0.3 u22.x86_64.pg18 : postgresql-18-pg-rrf postgresql-18-pg-rrf_0.0.3-3PIGSTY~jammy_amd64.deb PIGSTY · 0.0.3 · 760.3KiB	PIGSTY 0.0.3 u22.x86_64.pg17 : postgresql-17-pg-rrf postgresql-17-pg-rrf_0.0.3-3PIGSTY~jammy_amd64.deb PIGSTY · 0.0.3 · 757.5KiB	PIGSTY 0.0.3 u22.x86_64.pg16 : postgresql-16-pg-rrf postgresql-16-pg-rrf_0.0.3-3PIGSTY~jammy_amd64.deb PIGSTY · 0.0.3 · 758.0KiB	PIGSTY 0.0.3 u22.x86_64.pg15 : postgresql-15-pg-rrf postgresql-15-pg-rrf_0.0.3-3PIGSTY~jammy_amd64.deb PIGSTY · 0.0.3 · 748.6KiB	PIGSTY 0.0.3 u22.x86_64.pg14 : postgresql-14-pg-rrf postgresql-14-pg-rrf_0.0.3-3PIGSTY~jammy_amd64.deb PIGSTY · 0.0.3 · 745.8KiB
u22.aarch64	PIGSTY 0.0.3 u22.aarch64.pg18 : postgresql-18-pg-rrf postgresql-18-pg-rrf_0.0.3-3PIGSTY~jammy_arm64.deb PIGSTY · 0.0.3 · 670.8KiB	PIGSTY 0.0.3 u22.aarch64.pg17 : postgresql-17-pg-rrf postgresql-17-pg-rrf_0.0.3-3PIGSTY~jammy_arm64.deb PIGSTY · 0.0.3 · 668.3KiB	PIGSTY 0.0.3 u22.aarch64.pg16 : postgresql-16-pg-rrf postgresql-16-pg-rrf_0.0.3-3PIGSTY~jammy_arm64.deb PIGSTY · 0.0.3 · 667.8KiB	PIGSTY 0.0.3 u22.aarch64.pg15 : postgresql-15-pg-rrf postgresql-15-pg-rrf_0.0.3-3PIGSTY~jammy_arm64.deb PIGSTY · 0.0.3 · 663.1KiB	PIGSTY 0.0.3 u22.aarch64.pg14 : postgresql-14-pg-rrf postgresql-14-pg-rrf_0.0.3-3PIGSTY~jammy_arm64.deb PIGSTY · 0.0.3 · 661.1KiB
u24.x86_64	PIGSTY 0.0.3 u24.x86_64.pg18 : postgresql-18-pg-rrf postgresql-18-pg-rrf_0.0.3-3PIGSTY~noble_amd64.deb PIGSTY · 0.0.3 · 752.3KiB	PIGSTY 0.0.3 u24.x86_64.pg17 : postgresql-17-pg-rrf postgresql-17-pg-rrf_0.0.3-3PIGSTY~noble_amd64.deb PIGSTY · 0.0.3 · 749.3KiB	PIGSTY 0.0.3 u24.x86_64.pg16 : postgresql-16-pg-rrf postgresql-16-pg-rrf_0.0.3-3PIGSTY~noble_amd64.deb PIGSTY · 0.0.3 · 749.9KiB	PIGSTY 0.0.3 u24.x86_64.pg15 : postgresql-15-pg-rrf postgresql-15-pg-rrf_0.0.3-3PIGSTY~noble_amd64.deb PIGSTY · 0.0.3 · 741.0KiB	PIGSTY 0.0.3 u24.x86_64.pg14 : postgresql-14-pg-rrf postgresql-14-pg-rrf_0.0.3-3PIGSTY~noble_amd64.deb PIGSTY · 0.0.3 · 739.8KiB
u24.aarch64	PIGSTY 0.0.3 u24.aarch64.pg18 : postgresql-18-pg-rrf postgresql-18-pg-rrf_0.0.3-3PIGSTY~noble_arm64.deb PIGSTY · 0.0.3 · 662.5KiB	PIGSTY 0.0.3 u24.aarch64.pg17 : postgresql-17-pg-rrf postgresql-17-pg-rrf_0.0.3-3PIGSTY~noble_arm64.deb PIGSTY · 0.0.3 · 660.6KiB	PIGSTY 0.0.3 u24.aarch64.pg16 : postgresql-16-pg-rrf postgresql-16-pg-rrf_0.0.3-3PIGSTY~noble_arm64.deb PIGSTY · 0.0.3 · 659.6KiB	PIGSTY 0.0.3 u24.aarch64.pg15 : postgresql-15-pg-rrf postgresql-15-pg-rrf_0.0.3-3PIGSTY~noble_arm64.deb PIGSTY · 0.0.3 · 654.6KiB	PIGSTY 0.0.3 u24.aarch64.pg14 : postgresql-14-pg-rrf postgresql-14-pg-rrf_0.0.3-3PIGSTY~noble_arm64.deb PIGSTY · 0.0.3 · 652.5KiB
u26.x86_64	PIGSTY 0.0.3 u26.x86_64.pg18 : postgresql-18-pg-rrf postgresql-18-pg-rrf_0.0.3-3PIGSTY~resolute_amd64.deb PIGSTY · 0.0.3 · 747.8KiB	PIGSTY 0.0.3 u26.x86_64.pg17 : postgresql-17-pg-rrf postgresql-17-pg-rrf_0.0.3-3PIGSTY~resolute_amd64.deb PIGSTY · 0.0.3 · 745.7KiB	PIGSTY 0.0.3 u26.x86_64.pg16 : postgresql-16-pg-rrf postgresql-16-pg-rrf_0.0.3-3PIGSTY~resolute_amd64.deb PIGSTY · 0.0.3 · 745.3KiB	PIGSTY 0.0.3 u26.x86_64.pg15 : postgresql-15-pg-rrf postgresql-15-pg-rrf_0.0.3-3PIGSTY~resolute_amd64.deb PIGSTY · 0.0.3 · 737.2KiB	PIGSTY 0.0.3 u26.x86_64.pg14 : postgresql-14-pg-rrf postgresql-14-pg-rrf_0.0.3-3PIGSTY~resolute_amd64.deb PIGSTY · 0.0.3 · 735.1KiB
u26.aarch64	PIGSTY 0.0.3 u26.aarch64.pg18 : postgresql-18-pg-rrf postgresql-18-pg-rrf_0.0.3-3PIGSTY~resolute_arm64.deb PIGSTY · 0.0.3 · 661.5KiB	PIGSTY 0.0.3 u26.aarch64.pg17 : postgresql-17-pg-rrf postgresql-17-pg-rrf_0.0.3-3PIGSTY~resolute_arm64.deb PIGSTY · 0.0.3 · 659.2KiB	PIGSTY 0.0.3 u26.aarch64.pg16 : postgresql-16-pg-rrf postgresql-16-pg-rrf_0.0.3-3PIGSTY~resolute_arm64.deb PIGSTY · 0.0.3 · 658.6KiB	PIGSTY 0.0.3 u26.aarch64.pg15 : postgresql-15-pg-rrf postgresql-15-pg-rrf_0.0.3-3PIGSTY~resolute_arm64.deb PIGSTY · 0.0.3 · 652.9KiB	PIGSTY 0.0.3 u26.aarch64.pg14 : postgresql-14-pg-rrf postgresql-14-pg-rrf_0.0.3-3PIGSTY~resolute_arm64.deb PIGSTY · 0.0.3 · 650.8KiB

构建

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

pig build pkg pg_rrf         # 构建 RPM / DEB 包

安装

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

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

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

安装

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

pig

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

dnf

dnf install -y pg_rrf_18       # PG 18
dnf install -y pg_rrf_17       # PG 17
dnf install -y pg_rrf_16       # PG 16
dnf install -y pg_rrf_15       # PG 15
dnf install -y pg_rrf_14       # PG 14

apt

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

创建扩展：

CREATE EXTENSION pg_rrf;

用法

来源：README, v0.0.3 release

pg_rrf 提供用于混合检索分数融合的 Reciprocal Rank Fusion 函数。它的目标是把多个有序候选列表合并起来，而不需要手写 FULL OUTER JOIN / COALESCE 这类拼接逻辑。

核心函数

rrf(rank_a, rank_b, k)
rrf3(rank_a, rank_b, rank_c, k)
rrf_fuse(ids_a bigint[], ids_b bigint[], k int default 60)
rrfn(ranks bigint[], k int)

v0.0.3 release 明确新增了 rrfn，同时保留 rrf 和 rrf3 作为兼容包装器。README 记录的分数行为也很直接：

缺失排名会被忽略
<= 0 的排名会被忽略
k <= 0 会报错

示例

CREATE EXTENSION pg_rrf;

SELECT rrf(1, 2, 60) AS rrf_12;
SELECT rrf3(1, 2, 3, 60) AS rrf_123;
SELECT rrfn(ARRAY[1, 2, 3], 60) AS rrfn_123;
SELECT *
FROM rrf_fuse(ARRAY[10, 20, 30], ARRAY[20, 40], 60)
ORDER BY score DESC;

混合检索模式

上游 README 把 rrf_fuse 作为手工融合查询的替代方案：

WITH fused AS (
  SELECT *
  FROM rrf_fuse(
    ARRAY(SELECT id FROM docs ORDER BY bm25_score DESC LIMIT 100),
    ARRAY(SELECT id FROM docs ORDER BY embedding <=> :qvec LIMIT 100),
    60
  )
)
SELECT d.*, fused.score
FROM fused
JOIN docs d USING (id)
ORDER BY fused.score DESC
LIMIT 20;

说明

README 目标版本是 PostgreSQL 14-17，并记录了基于 Docker 的构建与测试流程。扩展接口刻意保持很小：核心是分数辅助函数，以及覆盖常见双列表混合检索场景的 rrf_fuse。

pg_rrf

概览

版本

构建

安装

用法

核心函数

示例

混合检索模式

说明

这个页面对您有帮助吗？