parray_gin

为 text[] 提供部分匹配运算符与 GIN 索引支持

概览

扩展包名	版本	分类	许可证	语言
`parray_gin`	`1.5.0`	FUNC	PostgreSQL	C

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

相关扩展	`intarray` `btree_gin` `btree_gist` `rum` `bloom` `ora_btree_gin` `orafce` `arraymath` `hll` `roaringbitmap`

PGXN dist name and PostgreSQL extension name are both parray_gin; Pigsty packages are built for PG 14-18.

版本

类型	仓库	版本	PG 大版本	包名	依赖
EXT	PIGSTY	`1.5.0`	1817161514	`parray_gin`	-
RPM	PIGSTY	`1.5.0`	1817161514	`parray_gin_$v`	-
DEB	PIGSTY	`1.5.0`	1817161514	`postgresql-$v-parray-gin`	-

OS / PG	PG18	PG17	PG16	PG15	PG14
el8.x86_64	PIGSTY 1.5.0 el8.x86_64.pg18 : parray_gin_18 parray_gin_18-1.5.0-1PIGSTY.el8.x86_64.rpm PIGSTY · 1.5.0 · 23.8KiB	PIGSTY 1.5.0 el8.x86_64.pg17 : parray_gin_17 parray_gin_17-1.5.0-1PIGSTY.el8.x86_64.rpm PIGSTY · 1.5.0 · 23.8KiB	PIGSTY 1.5.0 el8.x86_64.pg16 : parray_gin_16 parray_gin_16-1.5.0-1PIGSTY.el8.x86_64.rpm PIGSTY · 1.5.0 · 23.8KiB	PIGSTY 1.5.0 el8.x86_64.pg15 : parray_gin_15 parray_gin_15-1.5.0-1PIGSTY.el8.x86_64.rpm PIGSTY · 1.5.0 · 23.8KiB	PIGSTY 1.5.0 el8.x86_64.pg14 : parray_gin_14 parray_gin_14-1.5.0-1PIGSTY.el8.x86_64.rpm PIGSTY · 1.5.0 · 23.8KiB
el8.aarch64	PIGSTY 1.5.0 el8.aarch64.pg18 : parray_gin_18 parray_gin_18-1.5.0-1PIGSTY.el8.aarch64.rpm PIGSTY · 1.5.0 · 23.5KiB	PIGSTY 1.5.0 el8.aarch64.pg17 : parray_gin_17 parray_gin_17-1.5.0-1PIGSTY.el8.aarch64.rpm PIGSTY · 1.5.0 · 23.6KiB	PIGSTY 1.5.0 el8.aarch64.pg16 : parray_gin_16 parray_gin_16-1.5.0-1PIGSTY.el8.aarch64.rpm PIGSTY · 1.5.0 · 23.6KiB	PIGSTY 1.5.0 el8.aarch64.pg15 : parray_gin_15 parray_gin_15-1.5.0-1PIGSTY.el8.aarch64.rpm PIGSTY · 1.5.0 · 23.6KiB	PIGSTY 1.5.0 el8.aarch64.pg14 : parray_gin_14 parray_gin_14-1.5.0-1PIGSTY.el8.aarch64.rpm PIGSTY · 1.5.0 · 23.6KiB
el9.x86_64	PIGSTY 1.5.0 el9.x86_64.pg18 : parray_gin_18 parray_gin_18-1.5.0-1PIGSTY.el9.x86_64.rpm PIGSTY · 1.5.0 · 23.0KiB	PIGSTY 1.5.0 el9.x86_64.pg17 : parray_gin_17 parray_gin_17-1.5.0-1PIGSTY.el9.x86_64.rpm PIGSTY · 1.5.0 · 23.0KiB	PIGSTY 1.5.0 el9.x86_64.pg16 : parray_gin_16 parray_gin_16-1.5.0-1PIGSTY.el9.x86_64.rpm PIGSTY · 1.5.0 · 23.1KiB	PIGSTY 1.5.0 el9.x86_64.pg15 : parray_gin_15 parray_gin_15-1.5.0-1PIGSTY.el9.x86_64.rpm PIGSTY · 1.5.0 · 23.8KiB	PIGSTY 1.5.0 el9.x86_64.pg14 : parray_gin_14 parray_gin_14-1.5.0-1PIGSTY.el9.x86_64.rpm PIGSTY · 1.5.0 · 23.8KiB
el9.aarch64	PIGSTY 1.5.0 el9.aarch64.pg18 : parray_gin_18 parray_gin_18-1.5.0-1PIGSTY.el9.aarch64.rpm PIGSTY · 1.5.0 · 22.9KiB	PIGSTY 1.5.0 el9.aarch64.pg17 : parray_gin_17 parray_gin_17-1.5.0-1PIGSTY.el9.aarch64.rpm PIGSTY · 1.5.0 · 22.9KiB	PIGSTY 1.5.0 el9.aarch64.pg16 : parray_gin_16 parray_gin_16-1.5.0-1PIGSTY.el9.aarch64.rpm PIGSTY · 1.5.0 · 22.9KiB	PIGSTY 1.5.0 el9.aarch64.pg15 : parray_gin_15 parray_gin_15-1.5.0-1PIGSTY.el9.aarch64.rpm PIGSTY · 1.5.0 · 23.3KiB	PIGSTY 1.5.0 el9.aarch64.pg14 : parray_gin_14 parray_gin_14-1.5.0-1PIGSTY.el9.aarch64.rpm PIGSTY · 1.5.0 · 23.3KiB
el10.x86_64	PIGSTY 1.5.0 el10.x86_64.pg18 : parray_gin_18 parray_gin_18-1.5.0-1PIGSTY.el10.x86_64.rpm PIGSTY · 1.5.0 · 23.4KiB	PIGSTY 1.5.0 el10.x86_64.pg17 : parray_gin_17 parray_gin_17-1.5.0-1PIGSTY.el10.x86_64.rpm PIGSTY · 1.5.0 · 23.4KiB	PIGSTY 1.5.0 el10.x86_64.pg16 : parray_gin_16 parray_gin_16-1.5.0-1PIGSTY.el10.x86_64.rpm PIGSTY · 1.5.0 · 23.2KiB	PIGSTY 1.5.0 el10.x86_64.pg15 : parray_gin_15 parray_gin_15-1.5.0-1PIGSTY.el10.x86_64.rpm PIGSTY · 1.5.0 · 24.0KiB	PIGSTY 1.5.0 el10.x86_64.pg14 : parray_gin_14 parray_gin_14-1.5.0-1PIGSTY.el10.x86_64.rpm PIGSTY · 1.5.0 · 24.0KiB
el10.aarch64	PIGSTY 1.5.0 el10.aarch64.pg18 : parray_gin_18 parray_gin_18-1.5.0-1PIGSTY.el10.aarch64.rpm PIGSTY · 1.5.0 · 23.2KiB	PIGSTY 1.5.0 el10.aarch64.pg17 : parray_gin_17 parray_gin_17-1.5.0-1PIGSTY.el10.aarch64.rpm PIGSTY · 1.5.0 · 23.2KiB	PIGSTY 1.5.0 el10.aarch64.pg16 : parray_gin_16 parray_gin_16-1.5.0-1PIGSTY.el10.aarch64.rpm PIGSTY · 1.5.0 · 23.2KiB	PIGSTY 1.5.0 el10.aarch64.pg15 : parray_gin_15 parray_gin_15-1.5.0-1PIGSTY.el10.aarch64.rpm PIGSTY · 1.5.0 · 23.7KiB	PIGSTY 1.5.0 el10.aarch64.pg14 : parray_gin_14 parray_gin_14-1.5.0-1PIGSTY.el10.aarch64.rpm PIGSTY · 1.5.0 · 23.8KiB
d12.x86_64	PIGSTY 1.5.0 d12.x86_64.pg18 : postgresql-18-parray-gin postgresql-18-parray-gin_1.5.0-1PIGSTY~bookworm_amd64.deb PIGSTY · 1.5.0 · 30.2KiB	PIGSTY 1.5.0 d12.x86_64.pg17 : postgresql-17-parray-gin postgresql-17-parray-gin_1.5.0-1PIGSTY~bookworm_amd64.deb PIGSTY · 1.5.0 · 30.3KiB	PIGSTY 1.5.0 d12.x86_64.pg16 : postgresql-16-parray-gin postgresql-16-parray-gin_1.5.0-1PIGSTY~bookworm_amd64.deb PIGSTY · 1.5.0 · 30.3KiB	PIGSTY 1.5.0 d12.x86_64.pg15 : postgresql-15-parray-gin postgresql-15-parray-gin_1.5.0-1PIGSTY~bookworm_amd64.deb PIGSTY · 1.5.0 · 30.2KiB	PIGSTY 1.5.0 d12.x86_64.pg14 : postgresql-14-parray-gin postgresql-14-parray-gin_1.5.0-1PIGSTY~bookworm_amd64.deb PIGSTY · 1.5.0 · 30.1KiB
d12.aarch64	PIGSTY 1.5.0 d12.aarch64.pg18 : postgresql-18-parray-gin postgresql-18-parray-gin_1.5.0-1PIGSTY~bookworm_arm64.deb PIGSTY · 1.5.0 · 30.0KiB	PIGSTY 1.5.0 d12.aarch64.pg17 : postgresql-17-parray-gin postgresql-17-parray-gin_1.5.0-1PIGSTY~bookworm_arm64.deb PIGSTY · 1.5.0 · 30.2KiB	PIGSTY 1.5.0 d12.aarch64.pg16 : postgresql-16-parray-gin postgresql-16-parray-gin_1.5.0-1PIGSTY~bookworm_arm64.deb PIGSTY · 1.5.0 · 30.1KiB	PIGSTY 1.5.0 d12.aarch64.pg15 : postgresql-15-parray-gin postgresql-15-parray-gin_1.5.0-1PIGSTY~bookworm_arm64.deb PIGSTY · 1.5.0 · 30.0KiB	PIGSTY 1.5.0 d12.aarch64.pg14 : postgresql-14-parray-gin postgresql-14-parray-gin_1.5.0-1PIGSTY~bookworm_arm64.deb PIGSTY · 1.5.0 · 29.9KiB
d13.x86_64	PIGSTY 1.5.0 d13.x86_64.pg18 : postgresql-18-parray-gin postgresql-18-parray-gin_1.5.0-1PIGSTY~trixie_amd64.deb PIGSTY · 1.5.0 · 30.3KiB	PIGSTY 1.5.0 d13.x86_64.pg17 : postgresql-17-parray-gin postgresql-17-parray-gin_1.5.0-1PIGSTY~trixie_amd64.deb PIGSTY · 1.5.0 · 30.4KiB	PIGSTY 1.5.0 d13.x86_64.pg16 : postgresql-16-parray-gin postgresql-16-parray-gin_1.5.0-1PIGSTY~trixie_amd64.deb PIGSTY · 1.5.0 · 30.4KiB	PIGSTY 1.5.0 d13.x86_64.pg15 : postgresql-15-parray-gin postgresql-15-parray-gin_1.5.0-1PIGSTY~trixie_amd64.deb PIGSTY · 1.5.0 · 30.2KiB	PIGSTY 1.5.0 d13.x86_64.pg14 : postgresql-14-parray-gin postgresql-14-parray-gin_1.5.0-1PIGSTY~trixie_amd64.deb PIGSTY · 1.5.0 · 30.2KiB
d13.aarch64	PIGSTY 1.5.0 d13.aarch64.pg18 : postgresql-18-parray-gin postgresql-18-parray-gin_1.5.0-1PIGSTY~trixie_arm64.deb PIGSTY · 1.5.0 · 30.3KiB	PIGSTY 1.5.0 d13.aarch64.pg17 : postgresql-17-parray-gin postgresql-17-parray-gin_1.5.0-1PIGSTY~trixie_arm64.deb PIGSTY · 1.5.0 · 30.4KiB	PIGSTY 1.5.0 d13.aarch64.pg16 : postgresql-16-parray-gin postgresql-16-parray-gin_1.5.0-1PIGSTY~trixie_arm64.deb PIGSTY · 1.5.0 · 30.4KiB	PIGSTY 1.5.0 d13.aarch64.pg15 : postgresql-15-parray-gin postgresql-15-parray-gin_1.5.0-1PIGSTY~trixie_arm64.deb PIGSTY · 1.5.0 · 30.2KiB	PIGSTY 1.5.0 d13.aarch64.pg14 : postgresql-14-parray-gin postgresql-14-parray-gin_1.5.0-1PIGSTY~trixie_arm64.deb PIGSTY · 1.5.0 · 30.1KiB
u22.x86_64	PIGSTY 1.5.0 u22.x86_64.pg18 : postgresql-18-parray-gin postgresql-18-parray-gin_1.5.0-1PIGSTY~jammy_amd64.deb PIGSTY · 1.5.0 · 31.5KiB	PIGSTY 1.5.0 u22.x86_64.pg17 : postgresql-17-parray-gin postgresql-17-parray-gin_1.5.0-1PIGSTY~jammy_amd64.deb PIGSTY · 1.5.0 · 32.8KiB	PIGSTY 1.5.0 u22.x86_64.pg16 : postgresql-16-parray-gin postgresql-16-parray-gin_1.5.0-1PIGSTY~jammy_amd64.deb PIGSTY · 1.5.0 · 32.8KiB	PIGSTY 1.5.0 u22.x86_64.pg15 : postgresql-15-parray-gin postgresql-15-parray-gin_1.5.0-1PIGSTY~jammy_amd64.deb PIGSTY · 1.5.0 · 32.8KiB	PIGSTY 1.5.0 u22.x86_64.pg14 : postgresql-14-parray-gin postgresql-14-parray-gin_1.5.0-1PIGSTY~jammy_amd64.deb PIGSTY · 1.5.0 · 32.8KiB
u22.aarch64	PIGSTY 1.5.0 u22.aarch64.pg18 : postgresql-18-parray-gin postgresql-18-parray-gin_1.5.0-1PIGSTY~jammy_arm64.deb PIGSTY · 1.5.0 · 31.0KiB	PIGSTY 1.5.0 u22.aarch64.pg17 : postgresql-17-parray-gin postgresql-17-parray-gin_1.5.0-1PIGSTY~jammy_arm64.deb PIGSTY · 1.5.0 · 32.3KiB	PIGSTY 1.5.0 u22.aarch64.pg16 : postgresql-16-parray-gin postgresql-16-parray-gin_1.5.0-1PIGSTY~jammy_arm64.deb PIGSTY · 1.5.0 · 32.3KiB	PIGSTY 1.5.0 u22.aarch64.pg15 : postgresql-15-parray-gin postgresql-15-parray-gin_1.5.0-1PIGSTY~jammy_arm64.deb PIGSTY · 1.5.0 · 32.2KiB	PIGSTY 1.5.0 u22.aarch64.pg14 : postgresql-14-parray-gin postgresql-14-parray-gin_1.5.0-1PIGSTY~jammy_arm64.deb PIGSTY · 1.5.0 · 32.2KiB
u24.x86_64	PIGSTY 1.5.0 u24.x86_64.pg18 : postgresql-18-parray-gin postgresql-18-parray-gin_1.5.0-1PIGSTY~noble_amd64.deb PIGSTY · 1.5.0 · 31.1KiB	PIGSTY 1.5.0 u24.x86_64.pg17 : postgresql-17-parray-gin postgresql-17-parray-gin_1.5.0-1PIGSTY~noble_amd64.deb PIGSTY · 1.5.0 · 31.2KiB	PIGSTY 1.5.0 u24.x86_64.pg16 : postgresql-16-parray-gin postgresql-16-parray-gin_1.5.0-1PIGSTY~noble_amd64.deb PIGSTY · 1.5.0 · 31.2KiB	PIGSTY 1.5.0 u24.x86_64.pg15 : postgresql-15-parray-gin postgresql-15-parray-gin_1.5.0-1PIGSTY~noble_amd64.deb PIGSTY · 1.5.0 · 31.2KiB	PIGSTY 1.5.0 u24.x86_64.pg14 : postgresql-14-parray-gin postgresql-14-parray-gin_1.5.0-1PIGSTY~noble_amd64.deb PIGSTY · 1.5.0 · 31.2KiB
u24.aarch64	PIGSTY 1.5.0 u24.aarch64.pg18 : postgresql-18-parray-gin postgresql-18-parray-gin_1.5.0-1PIGSTY~noble_arm64.deb PIGSTY · 1.5.0 · 31.4KiB	PIGSTY 1.5.0 u24.aarch64.pg17 : postgresql-17-parray-gin postgresql-17-parray-gin_1.5.0-1PIGSTY~noble_arm64.deb PIGSTY · 1.5.0 · 31.5KiB	PIGSTY 1.5.0 u24.aarch64.pg16 : postgresql-16-parray-gin postgresql-16-parray-gin_1.5.0-1PIGSTY~noble_arm64.deb PIGSTY · 1.5.0 · 31.5KiB	PIGSTY 1.5.0 u24.aarch64.pg15 : postgresql-15-parray-gin postgresql-15-parray-gin_1.5.0-1PIGSTY~noble_arm64.deb PIGSTY · 1.5.0 · 31.5KiB	PIGSTY 1.5.0 u24.aarch64.pg14 : postgresql-14-parray-gin postgresql-14-parray-gin_1.5.0-1PIGSTY~noble_arm64.deb PIGSTY · 1.5.0 · 31.5KiB
u26.x86_64	PIGSTY 1.5.0 u26.x86_64.pg18 : postgresql-18-parray-gin postgresql-18-parray-gin_1.5.0-1PIGSTY~resolute_amd64.deb PIGSTY · 1.5.0 · 30.9KiB	PIGSTY 1.5.0 u26.x86_64.pg17 : postgresql-17-parray-gin postgresql-17-parray-gin_1.5.0-1PIGSTY~resolute_amd64.deb PIGSTY · 1.5.0 · 31.0KiB	PIGSTY 1.5.0 u26.x86_64.pg16 : postgresql-16-parray-gin postgresql-16-parray-gin_1.5.0-1PIGSTY~resolute_amd64.deb PIGSTY · 1.5.0 · 31.0KiB	PIGSTY 1.5.0 u26.x86_64.pg15 : postgresql-15-parray-gin postgresql-15-parray-gin_1.5.0-1PIGSTY~resolute_amd64.deb PIGSTY · 1.5.0 · 31.1KiB	PIGSTY 1.5.0 u26.x86_64.pg14 : postgresql-14-parray-gin postgresql-14-parray-gin_1.5.0-1PIGSTY~resolute_amd64.deb PIGSTY · 1.5.0 · 31.0KiB
u26.aarch64	PIGSTY 1.5.0 u26.aarch64.pg18 : postgresql-18-parray-gin postgresql-18-parray-gin_1.5.0-1PIGSTY~resolute_arm64.deb PIGSTY · 1.5.0 · 30.9KiB	PIGSTY 1.5.0 u26.aarch64.pg17 : postgresql-17-parray-gin postgresql-17-parray-gin_1.5.0-1PIGSTY~resolute_arm64.deb PIGSTY · 1.5.0 · 31.0KiB	PIGSTY 1.5.0 u26.aarch64.pg16 : postgresql-16-parray-gin postgresql-16-parray-gin_1.5.0-1PIGSTY~resolute_arm64.deb PIGSTY · 1.5.0 · 31.0KiB	PIGSTY 1.5.0 u26.aarch64.pg15 : postgresql-15-parray-gin postgresql-15-parray-gin_1.5.0-1PIGSTY~resolute_arm64.deb PIGSTY · 1.5.0 · 31.0KiB	PIGSTY 1.5.0 u26.aarch64.pg14 : postgresql-14-parray-gin postgresql-14-parray-gin_1.5.0-1PIGSTY~resolute_arm64.deb PIGSTY · 1.5.0 · 31.0KiB

构建

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

pig build pkg parray_gin         # 构建 RPM / DEB 包

安装

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

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

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

安装

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

pig

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

dnf

dnf install -y parray_gin_18       # PG 18
dnf install -y parray_gin_17       # PG 17
dnf install -y parray_gin_16       # PG 16
dnf install -y parray_gin_15       # PG 15
dnf install -y parray_gin_14       # PG 14

apt

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

创建扩展：

CREATE EXTENSION parray_gin;

用法

来源：README，reference doc

parray_gin 为 text[] 增加一个 GIN operator class，并提供严格匹配与部分匹配操作符。上游把它描述为基于 pg_trgm trigram 分解的数组索引。

创建扩展与索引

CREATE EXTENSION parray_gin;

CREATE TABLE test_table (
  id  bigserial,
  val text[]
);

CREATE INDEX test_tags_idx
ON test_table
USING gin (val parray_gin_ops);

可索引操作符

reference doc 说明 parray_gin_ops 支持下列操作符：

@>：严格包含。
<@：严格被包含。
@@>：部分包含，数组元素可以使用 LIKE 模式。
<@@：部分被包含。

示例：

SELECT * FROM test_table WHERE val @> ARRAY['must','contain'];
SELECT * FROM test_table WHERE val @@> ARRAY['what%like%'];
SELECT * FROM test_table WHERE val <@ ARRAY['galaxy','ago','vader'];
SELECT * FROM test_table WHERE val <@@ ARRAY['%ar%','vader'];

匹配行为

严格匹配要求数组元素完全相等。部分匹配允许 'foo%' 或 '%oo%' 这类模式。由于 trigram 索引可能返回误命中，文档说明索引查找之后还会做 recheck。

注意事项

README 表示支持范围一直到 PostgreSQL 18，而 reference doc 仍写成 9.1-14。两份文档对操作符和 opclass 行为的描述是一致的，但版本说明在上游尚未完全同步。

parray_gin

概览

版本

构建

安装

用法

创建扩展与索引

可索引操作符

匹配行为

注意事项

这个页面对您有帮助吗？