FTS - 全文检索

全文检索扩展：ES 替代 pg_search，BM25，中文分词，欧洲语言分词字典 hunspell，模糊检索，2-gram/3-gram 索引。

共有 22 个扩展包，包含 23 个扩展。

扩展	包	版本	许可证	语言	描述
pg_search	`pg_search`	`0.21.12`	AGPL-3.0	Rust	ParadeDB BM25算法全文检索插件，ES全文检索
pgroonga	`pgroonga`	`4.0.4`	PostgreSQL	C	使用Groonga，面向所有语言的高速全文检索平台
pgroonga_database	`pgroonga`	`4.0.4`	PostgreSQL	C	PGGroonga 数据库管理模块
pg_bigm	`pg_bigm`	`1.2`	PostgreSQL	C	基于二字组的多语言全文检索扩展
zhparser	`zhparser`	`2.3`	PostgreSQL	C	中文分词，全文搜索解析器
pg_bestmatch	`pg_bestmatch`	`0.0.2`	Apache-2.0	Rust	在数据库内生成BM25稀疏向量
vchord_bm25	`vchord_bm25`	`0.3.0`	AGPL-3.0	Rust	BM25排序算法
pg_tokenizer	`pg_tokenizer`	`0.1.1`	Apache-2.0	Rust	用于全文检索的分词器
biscuit	`pg_biscuit`	`2.2.2`	MIT	C	使用IAM的高性能文本模式匹配
pg_textsearch	`pg_textsearch`	`0.5.0`	PostgreSQL	C	带有BM25排序的全文搜索扩展
pg_pinyin	`pg_pinyin`	`0.0.2`	MIT	Rust	PostgreSQL 拼音转写与检索辅助扩展
hunspell_cs_cz	`hunspell_cs_cz`	`1.0`	PostgreSQL	Data	Hunspell捷克语全文检索词典
hunspell_de_de	`hunspell_de_de`	`1.0`	PostgreSQL	Data	Hunspell德语全文检索词典
hunspell_en_us	`hunspell_en_us`	`1.0`	PostgreSQL	Data	Hunspell英语全文检索词典
hunspell_fr	`hunspell_fr`	`1.0`	PostgreSQL	Data	Hunspell法语全文检索词典
hunspell_ne_np	`hunspell_ne_np`	`1.0`	PostgreSQL	Data	Hunspell尼泊尔语全文检索词典
hunspell_nl_nl	`hunspell_nl_nl`	`1.0`	PostgreSQL	Data	Hunspell荷兰语全文检索词典
hunspell_nn_no	`hunspell_nn_no`	`1.0`	PostgreSQL	Data	Hunspell挪威语全文检索词典
hunspell_pt_pt	`hunspell_pt_pt`	`1.0`	PostgreSQL	Data	Hunspell葡萄牙语全文检索词典
hunspell_ru_ru	`hunspell_ru_ru`	`1.0`	PostgreSQL	Data	Hunspell俄语全文检索词典
hunspell_ru_ru_aot	`hunspell_ru_ru_aot`	`1.0`	PostgreSQL	Data	Hunspell俄语全文检索词典（来自AOT.ru小组）
fuzzystrmatch	`fuzzystrmatch`	`1.2`	PostgreSQL	C	确定字符串之间的相似性和距离
pg_trgm	`pg_trgm`	`1.6`	PostgreSQL	C	文本相似度测量函数与模糊检索

pg_search - 0.21.12

ParadeDB BM25算法全文检索插件，ES全文检索

Extension	Website	Attributes
Package	`pg_search`
RPM	`pg_search_$v`	DDL
DEB	`postgresql-$v-pg-search`	LIB
Language	Rust	TRUST
License	AGPL-3.0

OS/Arch	x86_64					aarch64
el8	18	17	16	15	14	18	17	16	15	14
el9	18	17	16	15	14	18	17	16	15	14
el10	18	17	16	15		18	17	16	15
d12	18	17	16	15	14	18	17	16	15	14
d13	18	17	16	15	14	18	17	16	15	14
u22	18	17	16	15	14	18	17	16	15	14
u24	18	17	16	15	14	18	17	16	15	14

pgroonga - 4.0.4

使用Groonga，面向所有语言的高速全文检索平台

Extension	Website	Attributes
Package	`pgroonga`
RPM	`pgroonga_$v`	DDL
DEB	`postgresql-$v-pgroonga`	LIB
Language	C	TRUST
License	PostgreSQL

OS/Arch	x86_64					aarch64
el8	18	17	16	15	14	18	17	16	15	14
el9	18	17	16	15	14	18	17	16	15	14
el10	18	17	16	15	14	18	17	16	15	14
d12	18	17	16	15	14	18	17	16	15	14
d13	18	17	16	15	14	18	17	16	15	14
u22	18	17	16	15	14	18	17	16	15	14
u24	18	17	16	15	14	18	17	16	15	14

pg_bigm - 1.2

基于二字组的多语言全文检索扩展

Extension	Website	Attributes
Package	`pg_bigm`
RPM	`pg_bigm_$v`	DDL
DEB	`postgresql-$v-pg-bigm`	LIB
Language	C
License	PostgreSQL

OS/Arch	x86_64					aarch64
el8	18	17	16	15	14	18	17	16	15	14
el9	18	17	16	15	14	18	17	16	15	14
el10	18	17	16	15	14	18	17	16	15	14
d12	18	17	16	15	14	18	17	16	15	14
d13	18	17	16	15	14	18	17	16	15	14
u22	18	17	16	15	14	18	17	16	15	14
u24	18	17	16	15	14	18	17	16	15	14

zhparser - 2.3

中文分词，全文搜索解析器

Extension	Website	Attributes
Package	`zhparser`
RPM	`zhparser_$v`	DDL
DEB	`postgresql-$v-zhparser`	LIB
Language	C
License	PostgreSQL

OS/Arch	x86_64					aarch64
el8	18	17	16	15	14	18	17	16	15	14
el9	18	17	16	15	14	18	17	16	15	14
el10	18	17	16	15	14	18	17	16	15	14
d12	18	17	16	15	14	18	17	16	15	14
d13	18	17	16	15	14	18	17	16	15	14
u22	18	17	16	15	14	18	17	16	15	14
u24	18	17	16	15	14	18	17	16	15	14

pg_bestmatch - 0.0.2

在数据库内生成BM25稀疏向量

Extension	Website	Attributes
Package	`pg_bestmatch`
RPM	`pg_bestmatch_$v`	DDL
DEB	`postgresql-$v-pg-bestmatch`	LIB
Language	Rust
License	Apache-2.0

OS/Arch	x86_64					aarch64
el8	18	17	16	15	14	18	17	16	15	14
el9	18	17	16	15	14	18	17	16	15	14
el10	18	17	16	15	14	18	17	16	15	14
d12	18	17	16	15	14	18	17	16	15	14
d13	18	17	16	15	14	18	17	16	15	14
u22	18	17	16	15	14	18	17	16	15	14
u24	18	17	16	15	14	18	17	16	15	14

vchord_bm25 - 0.3.0

BM25排序算法

Extension	Website	Attributes
Package	`vchord_bm25`
RPM	`vchord_bm25_$v`	DDL
DEB	`postgresql-$v-vchord-bm25`	LIB
Language	Rust
License	AGPL-3.0

OS/Arch	x86_64					aarch64
el8	18	17	16	15	14	18	17	16	15	14
el9	18	17	16	15	14	18	17	16	15	14
el10	18	17	16	15	14	18	17	16	15	14
d12	18	17	16	15	14	18	17	16	15	14
d13	18	17	16	15	14	18	17	16	15	14
u22	18	17	16	15	14	18	17	16	15	14
u24	18	17	16	15	14	18	17	16	15	14

pg_tokenizer - 0.1.1

用于全文检索的分词器

Extension	Website	Attributes
Package	`pg_tokenizer`
RPM	`pg_tokenizer_$v`	DDL
DEB	`postgresql-$v-pg-tokenizer`	LIB
Language	Rust	TRUST
License	Apache-2.0

OS/Arch	x86_64					aarch64
el8	18	17	16	15	14	18	17	16	15	14
el9	18	17	16	15	14	18	17	16	15	14
el10	18	17	16	15	14	18	17	16	15	14
d12	18	17	16	15	14	18	17	16	15	14
d13	18	17	16	15	14	18	17	16	15	14
u22	18	17	16	15	14	18	17	16	15	14
u24	18	17	16	15	14	18	17	16	15	14

biscuit - 2.2.2

使用IAM的高性能文本模式匹配

Extension	Website	Attributes
Package	`pg_biscuit`
RPM	`pg_biscuit_$v`	DDL
DEB	`postgresql-$v-biscuit`	LIB
Language	C
License	MIT

OS/Arch	x86_64			aarch64
el8	18	17	16	18	17	16
el9	18	17	16	18	17	16
el10	18	17	16	18	17	16
d12	18	17	16	18	17	16
d13	18	17	16	18	17	16
u22	18	17	16	18	17	16
u24	18	17	16	18	17	16

pg_textsearch - 0.5.0

带有BM25排序的全文搜索扩展

Extension	Website	Attributes
Package	`pg_textsearch`
RPM	`pg_textsearch_$v`	DDL
DEB	`postgresql-$v-textsearch`	LIB
Language	C
License	PostgreSQL

OS/Arch	x86_64		aarch64
el8	18	17	18	17
el9	18	17	18	17
el10	18	17	18	17
d12	18	17	18	17
d13	18	17	18	17
u22	18	17	18	17
u24	18	17	18	17

pg_pinyin - 0.0.2

PostgreSQL 拼音转写与检索辅助扩展

Extension	Website	Attributes
Package	`pg_pinyin`
RPM	`pg_pinyin_$v`	DDL
DEB	`postgresql-$v-pinyin`	LIB
Language	Rust	TRUST
License	MIT

OS/Arch	x86_64					aarch64
el8	18	17	16	15	14	18	17	16	15	14
el9	18	17	16	15	14	18	17	16	15	14
el10	18	17	16	15	14	18	17	16	15	14
d12	18	17	16	15	14	18	17	16	15	14
d13	18	17	16	15	14	18	17	16	15	14
u22	18	17	16	15	14	18	17	16	15	14
u24	18	17	16	15	14	18	17	16	15	14

hunspell_cs_cz - 1.0

Hunspell捷克语全文检索词典

Extension	Website	Attributes
Package	`hunspell_cs_cz`
RPM	`hunspell_cs_cz_$v`	DDL
DEB	`postgresql-$v-hunspell-cs-cz`
Language	Data
License	PostgreSQL

OS/Arch	x86_64					aarch64
el8	18	17	16	15	14	18	17	16	15	14
el9	18	17	16	15	14	18	17	16	15	14
el10	18	17	16	15	14	18	17	16	15	14
d12	18	17	16	15	14	18	17	16	15	14
d13	18	17	16	15	14	18	17	16	15	14
u22	18	17	16	15	14	18	17	16	15	14
u24	18	17	16	15	14	18	17	16	15	14

hunspell_de_de - 1.0

Hunspell德语全文检索词典

Extension	Website	Attributes
Package	`hunspell_de_de`
RPM	`hunspell_de_de_$v`	DDL
DEB	`postgresql-$v-hunspell-de-de`
Language	Data
License	PostgreSQL

OS/Arch	x86_64					aarch64
el8	18	17	16	15	14	18	17	16	15	14
el9	18	17	16	15	14	18	17	16	15	14
el10	18	17	16	15	14	18	17	16	15	14
d12	18	17	16	15	14	18	17	16	15	14
d13	18	17	16	15	14	18	17	16	15	14
u22	18	17	16	15	14	18	17	16	15	14
u24	18	17	16	15	14	18	17	16	15	14

hunspell_en_us - 1.0

Hunspell英语全文检索词典

Extension	Website	Attributes
Package	`hunspell_en_us`
RPM	`hunspell_en_us_$v`	DDL
DEB	`postgresql-$v-hunspell-en-us`
Language	Data
License	PostgreSQL

OS/Arch	x86_64					aarch64
el8	18	17	16	15	14	18	17	16	15	14
el9	18	17	16	15	14	18	17	16	15	14
el10	18	17	16	15	14	18	17	16	15	14
d12	18	17	16	15	14	18	17	16	15	14
d13	18	17	16	15	14	18	17	16	15	14
u22	18	17	16	15	14	18	17	16	15	14
u24	18	17	16	15	14	18	17	16	15	14

hunspell_fr - 1.0

Hunspell法语全文检索词典

Extension	Website	Attributes
Package	`hunspell_fr`
RPM	`hunspell_fr_$v`	DDL
DEB	`postgresql-$v-hunspell-fr`
Language	Data
License	PostgreSQL

OS/Arch	x86_64					aarch64
el8	18	17	16	15	14	18	17	16	15	14
el9	18	17	16	15	14	18	17	16	15	14
el10	18	17	16	15	14	18	17	16	15	14
d12	18	17	16	15	14	18	17	16	15	14
d13	18	17	16	15	14	18	17	16	15	14
u22	18	17	16	15	14	18	17	16	15	14
u24	18	17	16	15	14	18	17	16	15	14

hunspell_ne_np - 1.0

Hunspell尼泊尔语全文检索词典

Extension	Website	Attributes
Package	`hunspell_ne_np`
RPM	`hunspell_ne_np_$v`	DDL
DEB	`postgresql-$v-hunspell-ne-np`
Language	Data
License	PostgreSQL

OS/Arch	x86_64					aarch64
el8	18	17	16	15	14	18	17	16	15	14
el9	18	17	16	15	14	18	17	16	15	14
el10	18	17	16	15	14	18	17	16	15	14
d12	18	17	16	15	14	18	17	16	15	14
d13	18	17	16	15	14	18	17	16	15	14
u22	18	17	16	15	14	18	17	16	15	14
u24	18	17	16	15	14	18	17	16	15	14

hunspell_nl_nl - 1.0

Hunspell荷兰语全文检索词典

Extension	Website	Attributes
Package	`hunspell_nl_nl`
RPM	`hunspell_nl_nl_$v`	DDL
DEB	`postgresql-$v-hunspell-nl-nl`
Language	Data
License	PostgreSQL

OS/Arch	x86_64					aarch64
el8	18	17	16	15	14	18	17	16	15	14
el9	18	17	16	15	14	18	17	16	15	14
el10	18	17	16	15	14	18	17	16	15	14
d12	18	17	16	15	14	18	17	16	15	14
d13	18	17	16	15	14	18	17	16	15	14
u22	18	17	16	15	14	18	17	16	15	14
u24	18	17	16	15	14	18	17	16	15	14

hunspell_nn_no - 1.0

Hunspell挪威语全文检索词典

Extension	Website	Attributes
Package	`hunspell_nn_no`
RPM	`hunspell_nn_no_$v`	DDL
DEB	`postgresql-$v-hunspell-nn-no`
Language	Data
License	PostgreSQL

OS/Arch	x86_64					aarch64
el8	18	17	16	15	14	18	17	16	15	14
el9	18	17	16	15	14	18	17	16	15	14
el10	18	17	16	15	14	18	17	16	15	14
d12	18	17	16	15	14	18	17	16	15	14
d13	18	17	16	15	14	18	17	16	15	14
u22	18	17	16	15	14	18	17	16	15	14
u24	18	17	16	15	14	18	17	16	15	14

hunspell_pt_pt - 1.0

Hunspell葡萄牙语全文检索词典

Extension	Website	Attributes
Package	`hunspell_pt_pt`
RPM	`hunspell_pt_pt_$v`	DDL
DEB	`postgresql-$v-hunspell-pt-pt`
Language	Data
License	PostgreSQL

OS/Arch	x86_64					aarch64
el8
el9
el10
d12
d13
u22
u24

hunspell_ru_ru - 1.0

Hunspell俄语全文检索词典

Extension	Website	Attributes
Package	`hunspell_ru_ru`
RPM	`hunspell_ru_ru_$v`	DDL
DEB	`postgresql-$v-hunspell-ru-ru`
Language	Data
License	PostgreSQL

OS/Arch	x86_64					aarch64
el8	18	17	16	15	14	18	17	16	15	14
el9	18	17	16	15	14	18	17	16	15	14
el10	18	17	16	15	14	18	17	16	15	14
d12	18	17	16	15	14	18	17	16	15	14
d13	18	17	16	15	14	18	17	16	15	14
u22	18	17	16	15	14	18	17	16	15	14
u24	18	17	16	15	14	18	17	16	15	14

hunspell_ru_ru_aot - 1.0

Hunspell俄语全文检索词典（来自AOT.ru小组）

Extension	Website	Attributes
Package	`hunspell_ru_ru_aot`
RPM	`hunspell_ru_ru_aot_$v`	DDL
DEB	`postgresql-$v-hunspell-ru-ru-aot`
Language	Data
License	PostgreSQL

OS/Arch	x86_64					aarch64
el8	18	17	16	15	14	18	17	16	15	14
el9	18	17	16	15	14	18	17	16	15	14
el10	18	17	16	15	14	18	17	16	15	14
d12	18	17	16	15	14	18	17	16	15	14
d13	18	17	16	15	14	18	17	16	15	14
u22	18	17	16	15	14	18	17	16	15	14
u24	18	17	16	15	14	18	17	16	15	14

fuzzystrmatch - 1.2

确定字符串之间的相似性和距离

Extension	Website	Attributes
Package	`fuzzystrmatch`
RPM	`postgresql$v-contrib`	DDL
DEB	`postgresql-$v`	LIB
Language	C	TRUST
License	PostgreSQL

OS/Arch	x86_64					aarch64
el8
el9
el10
d12
d13
u22
u24

pg_trgm - 1.6

文本相似度测量函数与模糊检索

Extension	Website	Attributes
Package	`pg_trgm`
RPM	`postgresql$v-contrib`	DDL
DEB	`postgresql-$v`	LIB
Language	C
License	PostgreSQL

OS/Arch	x86_64					aarch64
el8
el9
el10
d12
d13
u22
u24

意见反馈

这个页面对您有帮助吗？

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

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