FTS - 全文检索

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

扩展列表

共有 23 个扩展，位于 22 个扩展包中。

扩展包版本许可证语言描述
pg_searchpg_search0.21.12AGPL-3.0RustParadeDB BM25算法全文检索插件，ES全文检索
pgroongapgroonga4.0.4PostgreSQLC使用Groonga，面向所有语言的高速全文检索平台
pgroonga_databasepgroonga4.0.4PostgreSQLCPGGroonga 数据库管理模块
pg_bigmpg_bigm1.2PostgreSQLC基于二字组的多语言全文检索扩展
zhparserzhparser2.3PostgreSQLC中文分词，全文搜索解析器
pg_bestmatchpg_bestmatch0.0.2Apache-2.0Rust在数据库内生成BM25稀疏向量
vchord_bm25vchord_bm250.3.0AGPL-3.0RustBM25排序算法
pg_tokenizerpg_tokenizer0.1.1Apache-2.0Rust用于全文检索的分词器
biscuitpg_biscuit2.2.2MITC使用IAM的高性能文本模式匹配
pg_textsearchpg_textsearch0.5.0PostgreSQLC带有BM25排序的全文搜索扩展
pg_pinyinpg_pinyin0.0.2MITRustPostgreSQL 拼音转写与检索辅助扩展
hunspell_cs_czhunspell_cs_cz1.0PostgreSQLDataHunspell捷克语全文检索词典
hunspell_de_dehunspell_de_de1.0PostgreSQLDataHunspell德语全文检索词典
hunspell_en_ushunspell_en_us1.0PostgreSQLDataHunspell英语全文检索词典
hunspell_frhunspell_fr1.0PostgreSQLDataHunspell法语全文检索词典
hunspell_ne_nphunspell_ne_np1.0PostgreSQLDataHunspell尼泊尔语全文检索词典
hunspell_nl_nlhunspell_nl_nl1.0PostgreSQLDataHunspell荷兰语全文检索词典
hunspell_nn_nohunspell_nn_no1.0PostgreSQLDataHunspell挪威语全文检索词典
hunspell_pt_pthunspell_pt_pt1.0PostgreSQLDataHunspell葡萄牙语全文检索词典
hunspell_ru_ruhunspell_ru_ru1.0PostgreSQLDataHunspell俄语全文检索词典
hunspell_ru_ru_aothunspell_ru_ru_aot1.0PostgreSQLDataHunspell俄语全文检索词典（来自AOT.ru小组）
fuzzystrmatchfuzzystrmatch1.2PostgreSQLC确定字符串之间的相似性和距离
pg_trgmpg_trgm1.6PostgreSQLC文本相似度测量函数与模糊检索

pg_search - 0.21.12 : ParadeDB BM25算法全文检索插件，ES全文检索

条目属性OSx86_64aarch64
扩展名pg_searchel818171615141817161514
扩展包pg_searchel918171615141817161514
RPMpg_search_$vel1018171615141817161514
DEBpostgresql-$v-pg-searchd1218171615141817161514
语言Rustd1318171615141817161514
仓库PIGSTYu2218171615141817161514
协议AGPL-3.0u2418171615141817161514

pgroonga

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

条目属性OSx86_64aarch64
扩展名pgroongael818171615141817161514
扩展包pgroongael918171615141817161514
RPMpgroonga_$vel1018171615141817161514
DEBpostgresql-$v-pgroongad1218171615141817161514
语言Cd1318171615141817161514
仓库PIGSTYu2218171615141817161514
协议PostgreSQLu2418171615141817161514

pgroonga_database

pgroonga - 4.0.4 : PGGroonga 数据库管理模块

条目属性OSx86_64aarch64
扩展名pgroonga_databaseel818171615141817161514
扩展包pgroongael918171615141817161514
RPMpgroonga_$vel1018171615141817161514
DEBpostgresql-$v-pgroongad1218171615141817161514
语言Cd1318171615141817161514
仓库PIGSTYu2218171615141817161514
协议PostgreSQLu2418171615141817161514

pg_bigm

pg_bigm - 1.2 : 基于二字组的多语言全文检索扩展

条目属性OSx86_64aarch64
扩展名pg_bigmel818171615141817161514
扩展包pg_bigmel918171615141817161514
RPMpg_bigm_$vel1018171615141817161514
DEBpostgresql-$v-pg-bigmd1218171615141817161514
语言Cd1318171615141817161514
仓库MIXEDu2218171615141817161514
协议PostgreSQLu2418171615141817161514

zhparser

zhparser - 2.3 : 中文分词，全文搜索解析器

条目属性OSx86_64aarch64
扩展名zhparserel818171615141817161514
扩展包zhparserel918171615141817161514
RPMzhparser_$vel1018171615141817161514
DEBpostgresql-$v-zhparserd1218171615141817161514
语言Cd1318171615141817161514
仓库PIGSTYu2218171615141817161514
协议PostgreSQLu2418171615141817161514

pg_bestmatch

pg_bestmatch - 0.0.2 : 在数据库内生成BM25稀疏向量

条目属性OSx86_64aarch64
扩展名pg_bestmatchel818171615141817161514
扩展包pg_bestmatchel918171615141817161514
RPMpg_bestmatch_$vel1018171615141817161514
DEBpostgresql-$v-pg-bestmatchd1218171615141817161514
语言Rustd1318171615141817161514
仓库PIGSTYu2218171615141817161514
协议Apache-2.0u2418171615141817161514

vchord_bm25

vchord_bm25 - 0.3.0 : BM25排序算法

条目属性OSx86_64aarch64
扩展名vchord_bm25el818171615141817161514
扩展包vchord_bm25el918171615141817161514
RPMvchord_bm25_$vel1018171615141817161514
DEBpostgresql-$v-vchord-bm25d1218171615141817161514
语言Rustd1318171615141817161514
仓库PIGSTYu2218171615141817161514
协议AGPL-3.0u2418171615141817161514

pg_tokenizer

pg_tokenizer - 0.1.1 : 用于全文检索的分词器

条目属性OSx86_64aarch64
扩展名pg_tokenizerel818171615141817161514
扩展包pg_tokenizerel918171615141817161514
RPMpg_tokenizer_$vel1018171615141817161514
DEBpostgresql-$v-pg-tokenizerd1218171615141817161514
语言Rustd1318171615141817161514
仓库PIGSTYu2218171615141817161514
协议Apache-2.0u2418171615141817161514

biscuit

pg_biscuit - 2.2.2 : 使用IAM的高性能文本模式匹配

条目属性OSx86_64aarch64
扩展名biscuitel818171615141817161514
扩展包pg_biscuitel918171615141817161514
RPMpg_biscuit_$vel1018171615141817161514
DEBpostgresql-$v-biscuitd1218171615141817161514
语言Cd1318171615141817161514
仓库PIGSTYu2218171615141817161514
协议MITu2418171615141817161514

pg_textsearch

pg_textsearch - 0.5.0 : 带有BM25排序的全文搜索扩展

条目属性OSx86_64aarch64
扩展名pg_textsearchel818171615141817161514
扩展包pg_textsearchel918171615141817161514
RPMpg_textsearch_$vel1018171615141817161514
DEBpostgresql-$v-textsearchd1218171615141817161514
语言Cd1318171615141817161514
仓库PIGSTYu2218171615141817161514
协议PostgreSQLu2418171615141817161514

pg_pinyin

pg_pinyin - 0.0.2 : PostgreSQL 拼音转写与检索辅助扩展

条目属性OSx86_64aarch64
扩展名pg_pinyinel818171615141817161514
扩展包pg_pinyinel918171615141817161514
RPMpg_pinyin_$vel1018171615141817161514
DEBpostgresql-$v-pinyind1218171615141817161514
语言Rustd1318171615141817161514
仓库PIGSTYu2218171615141817161514
协议MITu2418171615141817161514

hunspell_cs_cz

hunspell_cs_cz - 1.0 : Hunspell捷克语全文检索词典

条目属性OSx86_64aarch64
扩展名hunspell_cs_czel818171615141817161514
扩展包hunspell_cs_czel918171615141817161514
RPMhunspell_cs_cz_$vel1018171615141817161514
DEBpostgresql-$v-hunspell-cs-czd1218171615141817161514
语言Datad1318171615141817161514
仓库PIGSTYu2218171615141817161514
协议PostgreSQLu2418171615141817161514

hunspell_de_de

hunspell_de_de - 1.0 : Hunspell德语全文检索词典

条目属性OSx86_64aarch64
扩展名hunspell_de_deel818171615141817161514
扩展包hunspell_de_deel918171615141817161514
RPMhunspell_de_de_$vel1018171615141817161514
DEBpostgresql-$v-hunspell-de-ded1218171615141817161514
语言Datad1318171615141817161514
仓库PIGSTYu2218171615141817161514
协议PostgreSQLu2418171615141817161514

hunspell_en_us

hunspell_en_us - 1.0 : Hunspell英语全文检索词典

条目属性OSx86_64aarch64
扩展名hunspell_en_usel818171615141817161514
扩展包hunspell_en_usel918171615141817161514
RPMhunspell_en_us_$vel1018171615141817161514
DEBpostgresql-$v-hunspell-en-usd1218171615141817161514
语言Datad1318171615141817161514
仓库PIGSTYu2218171615141817161514
协议PostgreSQLu2418171615141817161514

hunspell_fr

hunspell_fr - 1.0 : Hunspell法语全文检索词典

条目属性OSx86_64aarch64
扩展名hunspell_frel818171615141817161514
扩展包hunspell_frel918171615141817161514
RPMhunspell_fr_$vel1018171615141817161514
DEBpostgresql-$v-hunspell-frd1218171615141817161514
语言Datad1318171615141817161514
仓库PIGSTYu2218171615141817161514
协议PostgreSQLu2418171615141817161514

hunspell_ne_np

hunspell_ne_np - 1.0 : Hunspell尼泊尔语全文检索词典

条目属性OSx86_64aarch64
扩展名hunspell_ne_npel818171615141817161514
扩展包hunspell_ne_npel918171615141817161514
RPMhunspell_ne_np_$vel1018171615141817161514
DEBpostgresql-$v-hunspell-ne-npd1218171615141817161514
语言Datad1318171615141817161514
仓库PIGSTYu2218171615141817161514
协议PostgreSQLu2418171615141817161514

hunspell_nl_nl

hunspell_nl_nl - 1.0 : Hunspell荷兰语全文检索词典

条目属性OSx86_64aarch64
扩展名hunspell_nl_nlel818171615141817161514
扩展包hunspell_nl_nlel918171615141817161514
RPMhunspell_nl_nl_$vel1018171615141817161514
DEBpostgresql-$v-hunspell-nl-nld1218171615141817161514
语言Datad1318171615141817161514
仓库PIGSTYu2218171615141817161514
协议PostgreSQLu2418171615141817161514

hunspell_nn_no

hunspell_nn_no - 1.0 : Hunspell挪威语全文检索词典

条目属性OSx86_64aarch64
扩展名hunspell_nn_noel818171615141817161514
扩展包hunspell_nn_noel918171615141817161514
RPMhunspell_nn_no_$vel1018171615141817161514
DEBpostgresql-$v-hunspell-nn-nod1218171615141817161514
语言Datad1318171615141817161514
仓库PIGSTYu2218171615141817161514
协议PostgreSQLu2418171615141817161514

hunspell_pt_pt

hunspell_pt_pt - 1.0 : Hunspell葡萄牙语全文检索词典

条目属性OSx86_64aarch64
扩展名hunspell_pt_ptel8--
扩展包hunspell_pt_ptel9--
RPMhunspell_pt_pt_$vel10--
DEBpostgresql-$v-hunspell-pt-ptd12--
语言Datad13--
仓库PIGSTYu22--
协议PostgreSQLu24--

hunspell_ru_ru

hunspell_ru_ru - 1.0 : Hunspell俄语全文检索词典

条目属性OSx86_64aarch64
扩展名hunspell_ru_ruel818171615141817161514
扩展包hunspell_ru_ruel918171615141817161514
RPMhunspell_ru_ru_$vel1018171615141817161514
DEBpostgresql-$v-hunspell-ru-rud1218171615141817161514
语言Datad1318171615141817161514
仓库PIGSTYu2218171615141817161514
协议PostgreSQLu2418171615141817161514

hunspell_ru_ru_aot

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

条目属性OSx86_64aarch64
扩展名hunspell_ru_ru_aotel818171615141817161514
扩展包hunspell_ru_ru_aotel918171615141817161514
RPMhunspell_ru_ru_aot_$vel1018171615141817161514
DEBpostgresql-$v-hunspell-ru-ru-aotd1218171615141817161514
语言Datad1318171615141817161514
仓库PIGSTYu2218171615141817161514
协议PostgreSQLu2418171615141817161514

fuzzystrmatch

fuzzystrmatch - 1.2 : 确定字符串之间的相似性和距离

条目属性OSx86_64aarch64
扩展名fuzzystrmatchel818171615141817161514
扩展包fuzzystrmatchel918171615141817161514
RPMpostgresql$v-contribel1018171615141817161514
DEBpostgresql-$vd1218171615141817161514
语言Cd1318171615141817161514
仓库CONTRIBu2218171615141817161514
协议PostgreSQLu2418171615141817161514

pg_trgm

pg_trgm - 1.6 : 文本相似度测量函数与模糊检索

条目属性OSx86_64aarch64
扩展名pg_trgmel818171615141817161514
扩展包pg_trgmel918171615141817161514
RPMpostgresql$v-contribel1018171615141817161514
DEBpostgresql-$vd1218171615141817161514
语言Cd1318171615141817161514
仓库CONTRIBu2218171615141817161514
协议PostgreSQLu2418171615141817161514

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