FTS - Full-Text Search

ElasticSearch Alternative with BM25, 2-gram/3-gram Fuzzy Search, Zhparser & Hunspell Segregation Dicts, etc…

Extension List

There are 23 extensions in 22 packages.

ExtensionPackageVersionLicenseLanguageDescription
pg_searchpg_search0.21.12AGPL-3.0RustFull text search for PostgreSQL using BM25
pgroongapgroonga4.0.4PostgreSQLCUse Groonga as index, fast full text search platform for all languages!
pgroonga_databasepgroonga4.0.4PostgreSQLCPGroonga database management module
pg_bigmpg_bigm1.2PostgreSQLCcreate 2-gram (bigram) index for faster full text search.
zhparserzhparser2.3PostgreSQLCa parser for full-text search of Chinese
pg_bestmatchpg_bestmatch0.0.2Apache-2.0RustGenerate BM25 sparse vector inside PostgreSQL
vchord_bm25vchord_bm250.3.0AGPL-3.0RustA postgresql extension for bm25 ranking algorithm
pg_tokenizerpg_tokenizer0.1.1Apache-2.0RustTokenizers for full-text search
biscuitpg_biscuit2.2.2MITCIAM-LIKE pattern matching with bitmap indexing
pg_textsearchpg_textsearch0.5.0PostgreSQLCFull-text search with BM25 ranking
pg_pinyinpg_pinyin0.0.2MITRustPinyin romanization and search helpers for PostgreSQL
hunspell_cs_czhunspell_cs_cz1.0PostgreSQLDataCzech Hunspell Dictionary
hunspell_de_dehunspell_de_de1.0PostgreSQLDataGerman Hunspell Dictionary
hunspell_en_ushunspell_en_us1.0PostgreSQLDataen_US Hunspell Dictionary
hunspell_frhunspell_fr1.0PostgreSQLDataFrench Hunspell Dictionary
hunspell_ne_nphunspell_ne_np1.0PostgreSQLDataNepali Hunspell Dictionary
hunspell_nl_nlhunspell_nl_nl1.0PostgreSQLDataDutch Hunspell Dictionary
hunspell_nn_nohunspell_nn_no1.0PostgreSQLDataNorwegian (norsk) Hunspell Dictionary
hunspell_pt_pthunspell_pt_pt1.0PostgreSQLDataPortuguese Hunspell Dictionary
hunspell_ru_ruhunspell_ru_ru1.0PostgreSQLDataRussian Hunspell Dictionary
hunspell_ru_ru_aothunspell_ru_ru_aot1.0PostgreSQLDataRussian Hunspell Dictionary (from AOT.ru group)
fuzzystrmatchfuzzystrmatch1.2PostgreSQLCdetermine similarities and distance between strings
pg_trgmpg_trgm1.6PostgreSQLCtext similarity measurement and index searching based on trigrams

pg_search - 0.21.12 : Full text search for PostgreSQL using BM25

ItemValueOSx86_64aarch64
Extensionpg_searchel818171615141817161514
Packagepg_searchel918171615141817161514
RPMpg_search_$vel1018171615141817161514
DEBpostgresql-$v-pg-searchd1218171615141817161514
LanguageRustd1318171615141817161514
RepoPIGSTYu2218171615141817161514
LicenseAGPL-3.0u2418171615141817161514

pgroonga

pgroonga - 4.0.4 : Use Groonga as index, fast full text search platform for all languages!

ItemValueOSx86_64aarch64
Extensionpgroongael818171615141817161514
Packagepgroongael918171615141817161514
RPMpgroonga_$vel1018171615141817161514
DEBpostgresql-$v-pgroongad1218171615141817161514
LanguageCd1318171615141817161514
RepoPIGSTYu2218171615141817161514
LicensePostgreSQLu2418171615141817161514

pgroonga_database

pgroonga - 4.0.4 : PGroonga database management module

ItemValueOSx86_64aarch64
Extensionpgroonga_databaseel818171615141817161514
Packagepgroongael918171615141817161514
RPMpgroonga_$vel1018171615141817161514
DEBpostgresql-$v-pgroongad1218171615141817161514
LanguageCd1318171615141817161514
RepoPIGSTYu2218171615141817161514
LicensePostgreSQLu2418171615141817161514

pg_bigm

pg_bigm - 1.2 : create 2-gram (bigram) index for faster full text search.

ItemValueOSx86_64aarch64
Extensionpg_bigmel818171615141817161514
Packagepg_bigmel918171615141817161514
RPMpg_bigm_$vel1018171615141817161514
DEBpostgresql-$v-pg-bigmd1218171615141817161514
LanguageCd1318171615141817161514
RepoMIXEDu2218171615141817161514
LicensePostgreSQLu2418171615141817161514

zhparser

zhparser - 2.3 : a parser for full-text search of Chinese

ItemValueOSx86_64aarch64
Extensionzhparserel818171615141817161514
Packagezhparserel918171615141817161514
RPMzhparser_$vel1018171615141817161514
DEBpostgresql-$v-zhparserd1218171615141817161514
LanguageCd1318171615141817161514
RepoPIGSTYu2218171615141817161514
LicensePostgreSQLu2418171615141817161514

pg_bestmatch

pg_bestmatch - 0.0.2 : Generate BM25 sparse vector inside PostgreSQL

ItemValueOSx86_64aarch64
Extensionpg_bestmatchel818171615141817161514
Packagepg_bestmatchel918171615141817161514
RPMpg_bestmatch_$vel1018171615141817161514
DEBpostgresql-$v-pg-bestmatchd1218171615141817161514
LanguageRustd1318171615141817161514
RepoPIGSTYu2218171615141817161514
LicenseApache-2.0u2418171615141817161514

vchord_bm25

vchord_bm25 - 0.3.0 : A postgresql extension for bm25 ranking algorithm

ItemValueOSx86_64aarch64
Extensionvchord_bm25el818171615141817161514
Packagevchord_bm25el918171615141817161514
RPMvchord_bm25_$vel1018171615141817161514
DEBpostgresql-$v-vchord-bm25d1218171615141817161514
LanguageRustd1318171615141817161514
RepoPIGSTYu2218171615141817161514
LicenseAGPL-3.0u2418171615141817161514

pg_tokenizer

pg_tokenizer - 0.1.1 : Tokenizers for full-text search

ItemValueOSx86_64aarch64
Extensionpg_tokenizerel818171615141817161514
Packagepg_tokenizerel918171615141817161514
RPMpg_tokenizer_$vel1018171615141817161514
DEBpostgresql-$v-pg-tokenizerd1218171615141817161514
LanguageRustd1318171615141817161514
RepoPIGSTYu2218171615141817161514
LicenseApache-2.0u2418171615141817161514

biscuit

pg_biscuit - 2.2.2 : IAM-LIKE pattern matching with bitmap indexing

ItemValueOSx86_64aarch64
Extensionbiscuitel818171615141817161514
Packagepg_biscuitel918171615141817161514
RPMpg_biscuit_$vel1018171615141817161514
DEBpostgresql-$v-biscuitd1218171615141817161514
LanguageCd1318171615141817161514
RepoPIGSTYu2218171615141817161514
LicenseMITu2418171615141817161514

pg_textsearch

pg_textsearch - 0.5.0 : Full-text search with BM25 ranking

ItemValueOSx86_64aarch64
Extensionpg_textsearchel818171615141817161514
Packagepg_textsearchel918171615141817161514
RPMpg_textsearch_$vel1018171615141817161514
DEBpostgresql-$v-textsearchd1218171615141817161514
LanguageCd1318171615141817161514
RepoPIGSTYu2218171615141817161514
LicensePostgreSQLu2418171615141817161514

pg_pinyin

pg_pinyin - 0.0.2 : Pinyin romanization and search helpers for PostgreSQL

ItemValueOSx86_64aarch64
Extensionpg_pinyinel818171615141817161514
Packagepg_pinyinel918171615141817161514
RPMpg_pinyin_$vel1018171615141817161514
DEBpostgresql-$v-pinyind1218171615141817161514
LanguageRustd1318171615141817161514
RepoPIGSTYu2218171615141817161514
LicenseMITu2418171615141817161514

hunspell_cs_cz

hunspell_cs_cz - 1.0 : Czech Hunspell Dictionary

ItemValueOSx86_64aarch64
Extensionhunspell_cs_czel818171615141817161514
Packagehunspell_cs_czel918171615141817161514
RPMhunspell_cs_cz_$vel1018171615141817161514
DEBpostgresql-$v-hunspell-cs-czd1218171615141817161514
LanguageDatad1318171615141817161514
RepoPIGSTYu2218171615141817161514
LicensePostgreSQLu2418171615141817161514

hunspell_de_de

hunspell_de_de - 1.0 : German Hunspell Dictionary

ItemValueOSx86_64aarch64
Extensionhunspell_de_deel818171615141817161514
Packagehunspell_de_deel918171615141817161514
RPMhunspell_de_de_$vel1018171615141817161514
DEBpostgresql-$v-hunspell-de-ded1218171615141817161514
LanguageDatad1318171615141817161514
RepoPIGSTYu2218171615141817161514
LicensePostgreSQLu2418171615141817161514

hunspell_en_us

hunspell_en_us - 1.0 : en_US Hunspell Dictionary

ItemValueOSx86_64aarch64
Extensionhunspell_en_usel818171615141817161514
Packagehunspell_en_usel918171615141817161514
RPMhunspell_en_us_$vel1018171615141817161514
DEBpostgresql-$v-hunspell-en-usd1218171615141817161514
LanguageDatad1318171615141817161514
RepoPIGSTYu2218171615141817161514
LicensePostgreSQLu2418171615141817161514

hunspell_fr

hunspell_fr - 1.0 : French Hunspell Dictionary

ItemValueOSx86_64aarch64
Extensionhunspell_frel818171615141817161514
Packagehunspell_frel918171615141817161514
RPMhunspell_fr_$vel1018171615141817161514
DEBpostgresql-$v-hunspell-frd1218171615141817161514
LanguageDatad1318171615141817161514
RepoPIGSTYu2218171615141817161514
LicensePostgreSQLu2418171615141817161514

hunspell_ne_np

hunspell_ne_np - 1.0 : Nepali Hunspell Dictionary

ItemValueOSx86_64aarch64
Extensionhunspell_ne_npel818171615141817161514
Packagehunspell_ne_npel918171615141817161514
RPMhunspell_ne_np_$vel1018171615141817161514
DEBpostgresql-$v-hunspell-ne-npd1218171615141817161514
LanguageDatad1318171615141817161514
RepoPIGSTYu2218171615141817161514
LicensePostgreSQLu2418171615141817161514

hunspell_nl_nl

hunspell_nl_nl - 1.0 : Dutch Hunspell Dictionary

ItemValueOSx86_64aarch64
Extensionhunspell_nl_nlel818171615141817161514
Packagehunspell_nl_nlel918171615141817161514
RPMhunspell_nl_nl_$vel1018171615141817161514
DEBpostgresql-$v-hunspell-nl-nld1218171615141817161514
LanguageDatad1318171615141817161514
RepoPIGSTYu2218171615141817161514
LicensePostgreSQLu2418171615141817161514

hunspell_nn_no

hunspell_nn_no - 1.0 : Norwegian (norsk) Hunspell Dictionary

ItemValueOSx86_64aarch64
Extensionhunspell_nn_noel818171615141817161514
Packagehunspell_nn_noel918171615141817161514
RPMhunspell_nn_no_$vel1018171615141817161514
DEBpostgresql-$v-hunspell-nn-nod1218171615141817161514
LanguageDatad1318171615141817161514
RepoPIGSTYu2218171615141817161514
LicensePostgreSQLu2418171615141817161514

hunspell_pt_pt

hunspell_pt_pt - 1.0 : Portuguese Hunspell Dictionary

ItemValueOSx86_64aarch64
Extensionhunspell_pt_ptel8--
Packagehunspell_pt_ptel9--
RPMhunspell_pt_pt_$vel10--
DEBpostgresql-$v-hunspell-pt-ptd12--
LanguageDatad13--
RepoPIGSTYu22--
LicensePostgreSQLu24--

hunspell_ru_ru

hunspell_ru_ru - 1.0 : Russian Hunspell Dictionary

ItemValueOSx86_64aarch64
Extensionhunspell_ru_ruel818171615141817161514
Packagehunspell_ru_ruel918171615141817161514
RPMhunspell_ru_ru_$vel1018171615141817161514
DEBpostgresql-$v-hunspell-ru-rud1218171615141817161514
LanguageDatad1318171615141817161514
RepoPIGSTYu2218171615141817161514
LicensePostgreSQLu2418171615141817161514

hunspell_ru_ru_aot

hunspell_ru_ru_aot - 1.0 : Russian Hunspell Dictionary (from AOT.ru group)

ItemValueOSx86_64aarch64
Extensionhunspell_ru_ru_aotel818171615141817161514
Packagehunspell_ru_ru_aotel918171615141817161514
RPMhunspell_ru_ru_aot_$vel1018171615141817161514
DEBpostgresql-$v-hunspell-ru-ru-aotd1218171615141817161514
LanguageDatad1318171615141817161514
RepoPIGSTYu2218171615141817161514
LicensePostgreSQLu2418171615141817161514

fuzzystrmatch

fuzzystrmatch - 1.2 : determine similarities and distance between strings

ItemValueOSx86_64aarch64
Extensionfuzzystrmatchel818171615141817161514
Packagefuzzystrmatchel918171615141817161514
RPMpostgresql$v-contribel1018171615141817161514
DEBpostgresql-$vd1218171615141817161514
LanguageCd1318171615141817161514
RepoCONTRIBu2218171615141817161514
LicensePostgreSQLu2418171615141817161514

pg_trgm

pg_trgm - 1.6 : text similarity measurement and index searching based on trigrams

ItemValueOSx86_64aarch64
Extensionpg_trgmel818171615141817161514
Packagepg_trgmel918171615141817161514
RPMpostgresql$v-contribel1018171615141817161514
DEBpostgresql-$vd1218171615141817161514
LanguageCd1318171615141817161514
RepoCONTRIBu2218171615141817161514
LicensePostgreSQLu2418171615141817161514

Last Modified 2026-03-12: add pg extension catalog (95749bf)