FTS - Full-Text Search

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

Extension List

There are 28 extensions in 18 packages.

ExtensionPackageVersionLicenseLanguageDescription
pg_searchpg_search0.24.3AGPL-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.4.3MITCIAM-LIKE pattern matching with bitmap indexing
pg_textsearchpg_textsearch1.2.0PostgreSQLCFull-text search with BM25 ranking
pg_pinyinpg_pinyin0.0.5MITRustPinyin romanization and search helpers for PostgreSQL
pg_kazsearchpg_kazsearch2.3.0LGPL-3.0RustKazakh full-text search extension for PostgreSQL
psql_bm25spsql_bm25s0.4.13Apache-2.0CPostgreSQL extension for BM25-family lexical retrieval
pg_ftspg_fts0.2.0PostgreSQLCFull-text search with BM25 and BM25F ranking
pg_cjk_parserpg_cjk_parser0.1.0PostgreSQLCCJK bigram parser derived from PostgreSQL full-text search
pg_jiebapg_jieba1.1.0BSD-3-ClauseC++Chinese full-text search parser based on cppjieba
hunspell_cs_czhunspell1.0PostgreSQLDataCzech Hunspell Dictionary
hunspell_de_dehunspell1.0PostgreSQLDataGerman Hunspell Dictionary
hunspell_en_ushunspell1.0PostgreSQLDataen_US Hunspell Dictionary
hunspell_frhunspell1.0PostgreSQLDataFrench Hunspell Dictionary
hunspell_ne_nphunspell1.0PostgreSQLDataNepali Hunspell Dictionary
hunspell_nl_nlhunspell1.0PostgreSQLDataDutch Hunspell Dictionary
hunspell_nn_nohunspell1.0PostgreSQLDataNorwegian (norsk) Hunspell Dictionary
hunspell_pt_pthunspell1.0PostgreSQLDataPortuguese Hunspell Dictionary
hunspell_ru_ruhunspell1.0PostgreSQLDataRussian Hunspell Dictionary
hunspell_ru_ru_aothunspell1.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.24.3 : 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
u2618171615141817161514

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
u2618171615141817161514

pgroonga_database

pgroonga - 4.0.4 : PGroonga database management module

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

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
u2618171615141817161514

zhparser

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

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

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
u2618171615141817161514

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
u2618171615141817161514

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
u2618171615141817161514

biscuit

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

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

pg_textsearch

pg_textsearch - 1.2.0 : Full-text search with BM25 ranking

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

pg_pinyin

pg_pinyin - 0.0.5 : Pinyin romanization and search helpers for PostgreSQL

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

pg_kazsearch

pg_kazsearch - 2.3.0 : Kazakh full-text search extension for PostgreSQL

ItemValueOSx86_64aarch64
Extensionpg_kazsearchel818171615141817161514
Packagepg_kazsearchel918171615141817161514
RPMpg_kazsearch_$vel1018171615141817161514
DEBpostgresql-$v-pg-kazsearchd1218171615141817161514
LanguageRustd1318171615141817161514
RepoPIGSTYu2218171615141817161514
LicenseLGPL-3.0u2418171615141817161514
u2618171615141817161514

psql_bm25s

psql_bm25s - 0.4.13 : PostgreSQL extension for BM25-family lexical retrieval

ItemValueOSx86_64aarch64
Extensionpsql_bm25sel818171615141817161514
Packagepsql_bm25sel918171615141817161514
RPMpsql_bm25s_$vel1018171615141817161514
DEBpostgresql-$v-psql-bm25sd1218171615141817161514
LanguageCd1318171615141817161514
RepoPIGSTYu2218171615141817161514
LicenseApache-2.0u2418171615141817161514
u2618171615141817161514

pg_fts

pg_fts - 0.2.0 : Full-text search with BM25 and BM25F ranking

ItemValueOSx86_64aarch64
Extensionpg_ftsel818171615141817161514
Packagepg_ftsel918171615141817161514
RPMpg_fts_$vel1018171615141817161514
DEBpostgresql-$v-pg-ftsd1218171615141817161514
LanguageCd1318171615141817161514
RepoPIGSTYu2218171615141817161514
LicensePostgreSQLu2418171615141817161514
u2618171615141817161514

pg_cjk_parser

pg_cjk_parser - 0.1.0 : CJK bigram parser derived from PostgreSQL full-text search

ItemValueOSx86_64aarch64
Extensionpg_cjk_parserel818171615141817161514
Packagepg_cjk_parserel918171615141817161514
RPMpg_cjk_parser_$vel1018171615141817161514
DEBpostgresql-$v-pg-cjk-parserd1218171615141817161514
LanguageCd1318171615141817161514
RepoPIGSTYu2218171615141817161514
LicensePostgreSQLu2418171615141817161514
u2618171615141817161514

pg_jieba

pg_jieba - 1.1.0 : Chinese full-text search parser based on cppjieba

ItemValueOSx86_64aarch64
Extensionpg_jiebael818171615141817161514
Packagepg_jiebael918171615141817161514
RPMpg_jieba_$vel1018171615141817161514
DEBpostgresql-$v-pg-jiebad1218171615141817161514
LanguageC++d1318171615141817161514
RepoPIGSTYu2218171615141817161514
LicenseBSD-3-Clauseu2418171615141817161514
u2618171615141817161514

hunspell_cs_cz

hunspell - 1.0 : Czech Hunspell Dictionary

ItemValueOSx86_64aarch64
Extensionhunspell_cs_czel818171615141817161514
Packagehunspellel918171615141817161514
RPMhunspell_$vel1018171615141817161514
DEBpostgresql-$v-hunspelld1218171615141817161514
LanguageDatad1318171615141817161514
RepoPIGSTYu2218171615141817161514
LicensePostgreSQLu2418171615141817161514
u2618171615141817161514

hunspell_de_de

hunspell - 1.0 : German Hunspell Dictionary

ItemValueOSx86_64aarch64
Extensionhunspell_de_deel818171615141817161514
Packagehunspellel918171615141817161514
RPMhunspell_$vel1018171615141817161514
DEBpostgresql-$v-hunspelld1218171615141817161514
LanguageDatad1318171615141817161514
RepoPIGSTYu2218171615141817161514
LicensePostgreSQLu2418171615141817161514
u2618171615141817161514

hunspell_en_us

hunspell - 1.0 : en_US Hunspell Dictionary

ItemValueOSx86_64aarch64
Extensionhunspell_en_usel818171615141817161514
Packagehunspellel918171615141817161514
RPMhunspell_$vel1018171615141817161514
DEBpostgresql-$v-hunspelld1218171615141817161514
LanguageDatad1318171615141817161514
RepoPIGSTYu2218171615141817161514
LicensePostgreSQLu2418171615141817161514
u2618171615141817161514

hunspell_fr

hunspell - 1.0 : French Hunspell Dictionary

ItemValueOSx86_64aarch64
Extensionhunspell_frel818171615141817161514
Packagehunspellel918171615141817161514
RPMhunspell_$vel1018171615141817161514
DEBpostgresql-$v-hunspelld1218171615141817161514
LanguageDatad1318171615141817161514
RepoPIGSTYu2218171615141817161514
LicensePostgreSQLu2418171615141817161514
u2618171615141817161514

hunspell_ne_np

hunspell - 1.0 : Nepali Hunspell Dictionary

ItemValueOSx86_64aarch64
Extensionhunspell_ne_npel818171615141817161514
Packagehunspellel918171615141817161514
RPMhunspell_$vel1018171615141817161514
DEBpostgresql-$v-hunspelld1218171615141817161514
LanguageDatad1318171615141817161514
RepoPIGSTYu2218171615141817161514
LicensePostgreSQLu2418171615141817161514
u2618171615141817161514

hunspell_nl_nl

hunspell - 1.0 : Dutch Hunspell Dictionary

ItemValueOSx86_64aarch64
Extensionhunspell_nl_nlel818171615141817161514
Packagehunspellel918171615141817161514
RPMhunspell_$vel1018171615141817161514
DEBpostgresql-$v-hunspelld1218171615141817161514
LanguageDatad1318171615141817161514
RepoPIGSTYu2218171615141817161514
LicensePostgreSQLu2418171615141817161514
u2618171615141817161514

hunspell_nn_no

hunspell - 1.0 : Norwegian (norsk) Hunspell Dictionary

ItemValueOSx86_64aarch64
Extensionhunspell_nn_noel818171615141817161514
Packagehunspellel918171615141817161514
RPMhunspell_$vel1018171615141817161514
DEBpostgresql-$v-hunspelld1218171615141817161514
LanguageDatad1318171615141817161514
RepoPIGSTYu2218171615141817161514
LicensePostgreSQLu2418171615141817161514
u2618171615141817161514

hunspell_pt_pt

hunspell - 1.0 : Portuguese Hunspell Dictionary

ItemValueOSx86_64aarch64
Extensionhunspell_pt_ptel818171615141817161514
Packagehunspellel918171615141817161514
RPMhunspell_$vel1018171615141817161514
DEBpostgresql-$v-hunspelld1218171615141817161514
LanguageDatad1318171615141817161514
RepoPIGSTYu2218171615141817161514
LicensePostgreSQLu2418171615141817161514
u2618171615141817161514

hunspell_ru_ru

hunspell - 1.0 : Russian Hunspell Dictionary

ItemValueOSx86_64aarch64
Extensionhunspell_ru_ruel818171615141817161514
Packagehunspellel918171615141817161514
RPMhunspell_$vel1018171615141817161514
DEBpostgresql-$v-hunspelld1218171615141817161514
LanguageDatad1318171615141817161514
RepoPIGSTYu2218171615141817161514
LicensePostgreSQLu2418171615141817161514
u2618171615141817161514

hunspell_ru_ru_aot

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

ItemValueOSx86_64aarch64
Extensionhunspell_ru_ru_aotel818171615141817161514
Packagehunspellel918171615141817161514
RPMhunspell_$vel1018171615141817161514
DEBpostgresql-$v-hunspelld1218171615141817161514
LanguageDatad1318171615141817161514
RepoPIGSTYu2218171615141817161514
LicensePostgreSQLu2418171615141817161514
u2618171615141817161514

fuzzystrmatch

fuzzystrmatch - 1.2 : determine similarities and distance between strings

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

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
u2618171615141817161514

Last Modified 2026-07-23: update extension list to 555 (d81fc56)