select open change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Extensions / Full-text search

pg_bigm

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

pgext.cloud · Source code · License text · Control file

Overview

Packagepg_bigm
Version1.2
PostgreSQL versions14 · 15 · 16 · 17 · 18
RepositoryMultiple repositories
Extension typePreloaded
Requires CREATE EXTENSIONYes
Requires preloadYes
TrustedNo
RelocatableYes
Shared librariespg_bigm
Stars152
Latest commit2026-08-04
Latest release2025-09-02
Catalogue updated2026-08-30

Related extensions

See also

pgroongaUse Groonga as index, fast full text search platform for all languages!
pg_cjk_parserCJK bigram parser derived from PostgreSQL full-text search
pg_jiebaChinese full-text search parser based on cppjieba
zhparsera parser for full-text search of Chinese
pg_tokenizerTokenizers for full-text search
pg_pinyinPinyin romanization and search helpers for PostgreSQL
unaccenttext search dictionary that removes accents
pg_trgmtext similarity measurement and index searching based on trigrams
dict_xsyntext search dictionary template for extended synonym processing
biscuitIAM-LIKE pattern matching with bitmap indexing