PIGSTY

FTS

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

FTS category contains 20 PostgreSQL extensions.

IDExtensionPackageVersionDescription
2100pg_searchpg_search0.16.2Full text search for PostgreSQL using BM25
2110pgroongapgroonga4.0.0Use Groonga as index, fast full text search platform for all languages!
2111pgroonga_databasepgroonga4.0.0PGroonga database management module
2120pg_bigmpg_bigm1.2create 2-gram (bigram) index for faster full text search.
2130zhparserzhparser2.3a parser for full-text search of Chinese
2140pg_bestmatchpg_bestmatch0.0.1Generate BM25 sparse vector inside PostgreSQL
2150vchord_bm25vchord_bm250.2.1A postgresql extension for bm25 ranking algorithm
2160pg_tokenizerpg_tokenizer0.1.0Tokenizers for full-text search
2170hunspell_cs_czhunspell_cs_cz1.0Czech Hunspell Dictionary
2171hunspell_de_dehunspell_de_de1.0German Hunspell Dictionary
2172hunspell_en_ushunspell_en_us1.0en_US Hunspell Dictionary
2173hunspell_frhunspell_fr1.0French Hunspell Dictionary
2174hunspell_ne_nphunspell_ne_np1.0Nepali Hunspell Dictionary
2175hunspell_nl_nlhunspell_nl_nl1.0Dutch Hunspell Dictionary
2176hunspell_nn_nohunspell_nn_no1.0Norwegian (norsk) Hunspell Dictionary
2177hunspell_pt_pthunspell_pt_pt1.0Portuguese Hunspell Dictionary
2178hunspell_ru_ruhunspell_ru_ru1.0Russian Hunspell Dictionary
2179hunspell_ru_ru_aothunspell_ru_ru_aot1.0Russian Hunspell Dictionary (from AOT.ru group)
2180fuzzystrmatchfuzzystrmatch1.2determine similarities and distance between strings
2190pg_trgmpg_trgm1.6text similarity measurement and index searching based on trigrams

pg_search - 0.16.2

Full text search for PostgreSQL using BM25

ExtensionWebsiteAttributes
Packagepg_search
RPMpg_search_$v
DDL
DEBpostgresql-$v-pg-search
LIB
Language
Rust
License
AGPL-3.0
TRUST
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

pgroonga - 4.0.0

Use Groonga as index, fast full text search platform for all languages!

ExtensionWebsiteAttributes
Packagepgroonga
RPMpgroonga_$v*
DDL
DEBpostgresql-$v-pgroonga
LIB
Language
C
License
PostgreSQL
TRUST
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

pgroonga_database - 4.0.0

PGroonga database management module

ExtensionWebsiteAttributes
Packagepgroonga
RPMpgroonga_$v*
DDL
DEBpostgresql-$v-pgroonga
LIB
Language
C
License
PostgreSQL
TRUST
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

pg_bigm - 1.2

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

ExtensionWebsiteAttributes
Packagepg_bigm
RPMpg_bigm_$v*
DDL
DEBpostgresql-$v-pg-bigm
LIB
Language
C
License
PostgreSQL
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

zhparser - 2.3

a parser for full-text search of Chinese

ExtensionWebsiteAttributes
Packagezhparser
RPMzhparser_$v*
DDL
DEBpostgresql-$v-zhparser
LIB
Language
C
License
PostgreSQL
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

pg_bestmatch - 0.0.1

Generate BM25 sparse vector inside PostgreSQL

ExtensionWebsiteAttributes
Packagepg_bestmatch
LOAD
RPMpg_bestmatch_$v
DDL
DEBpostgresql-$v-pg-bestmatch
LIB
Language
Rust
License
Apache-2.0
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

vchord_bm25 - 0.2.1

A postgresql extension for bm25 ranking algorithm

ExtensionWebsiteAttributes
Packagevchord_bm25
LOAD
RPMvchord_bm25_$v
DDL
DEBpostgresql-$v-vchord-bm25
LIB
Language
Rust
License
AGPL-3.0
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

pg_tokenizer - 0.1.0

Tokenizers for full-text search

ExtensionWebsiteAttributes
Packagepg_tokenizer
RPMpg_tokenizer_$v
DDL
DEBpostgresql-$v-pg-tokenizer
LIB
Language
Rust
License
Apache-2.0
TRUST
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

hunspell_cs_cz - 1.0

Czech Hunspell Dictionary

ExtensionWebsiteAttributes
Packagehunspell_cs_cz
RPMhunspell_cs_cz_$v
DDL
DEBpostgresql-$v-hunspell-cs-cz
Language
Data
License
PostgreSQL
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

hunspell_de_de - 1.0

German Hunspell Dictionary

ExtensionWebsiteAttributes
Packagehunspell_de_de
RPMhunspell_de_de_$v
DDL
DEBpostgresql-$v-hunspell-de-de
Language
Data
License
PostgreSQL
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

hunspell_en_us - 1.0

en_US Hunspell Dictionary

ExtensionWebsiteAttributes
Packagehunspell_en_us
RPMhunspell_en_us_$v
DDL
DEBpostgresql-$v-hunspell-en-us
Language
Data
License
PostgreSQL
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

hunspell_fr - 1.0

French Hunspell Dictionary

ExtensionWebsiteAttributes
Packagehunspell_fr
RPMhunspell_fr_$v
DDL
DEBpostgresql-$v-hunspell-fr
Language
Data
License
PostgreSQL
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

hunspell_ne_np - 1.0

Nepali Hunspell Dictionary

ExtensionWebsiteAttributes
Packagehunspell_ne_np
RPMhunspell_ne_np_$v
DDL
DEBpostgresql-$v-hunspell-ne-np
Language
Data
License
PostgreSQL
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

hunspell_nl_nl - 1.0

Dutch Hunspell Dictionary

ExtensionWebsiteAttributes
Packagehunspell_nl_nl
RPMhunspell_nl_nl_$v
DDL
DEBpostgresql-$v-hunspell-nl-nl
Language
Data
License
PostgreSQL
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

hunspell_nn_no - 1.0

Norwegian (norsk) Hunspell Dictionary

ExtensionWebsiteAttributes
Packagehunspell_nn_no
RPMhunspell_nn_no_$v
DDL
DEBpostgresql-$v-hunspell-nn-no
Language
Data
License
PostgreSQL
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

hunspell_pt_pt - 1.0

Portuguese Hunspell Dictionary

ExtensionWebsiteAttributes
Packagehunspell_pt_pt
RPMhunspell_pt_pt_$v
DDL
DEBpostgresql-$v-hunspell-pt-pt
Language
Data
License
PostgreSQL
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

hunspell_ru_ru - 1.0

Russian Hunspell Dictionary

ExtensionWebsiteAttributes
Packagehunspell_ru_ru
RPMhunspell_ru_ru_$v
DDL
DEBpostgresql-$v-hunspell-ru-ru
Language
Data
License
PostgreSQL
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

hunspell_ru_ru_aot - 1.0

Russian Hunspell Dictionary (from AOT.ru group)

ExtensionWebsiteAttributes
Packagehunspell_ru_ru_aot
RPMhunspell_ru_ru_aot_$v
DDL
DEBpostgresql-$v-hunspell-ru-ru-aot
Language
Data
License
PostgreSQL
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

fuzzystrmatch - 1.2

determine similarities and distance between strings

ExtensionWebsiteAttributes
Packagefuzzystrmatch
RPMpostgresql$v-contrib
DDL
DEBpostgresql-$v
LIB
Language
C
License
PostgreSQL
TRUST
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

pg_trgm - 1.6

text similarity measurement and index searching based on trigrams

ExtensionWebsiteAttributes
Packagepg_trgm
RPMpostgresql$v-contrib
DDL
DEBpostgresql-$v
LIB
Language
C
License
PostgreSQL
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13