pg_bigm

pg_bigm

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

Overview

IDExtensionPackageVersionCategoryLicenseLanguage
2120
pg_bigm
pg_bigm
1.2
FTS
PostgreSQL
C
AttributeHas BinaryHas LibraryNeed LoadHas DDLRelocatableTrusted
--s-d-r
No
Yes
No
Yes
yes
no
Relationships
See Also
pg_search
pgroonga
zhparser
pg_trgm
pgroonga_database
pg_tokenizer
fuzzystrmatch
rum

Packages

TypeRepoVersionPG Major CompatibilityPackage PatternDependencies
EXT
MIXED
1.2
18
17
16
15
14
13
pg_bigm-
RPM
PGDG
1.2
18
17
16
15
14
13
pg_bigm_$v*-
DEB
PIGSTY
1.2
18
17
16
15
14
13
postgresql-$v-pg-bigm-
Linux / PGPG18PG17PG16PG15PG14PG13
el8.x86_64
PGDG 1.2
PGDG 1.2
PGDG 1.2
PGDG 1.2
PGDG 1.2
PGDG 1.2
el8.aarch64
PGDG 1.2
PGDG 1.2
PGDG 1.2
PGDG 1.2
PGDG 1.2
PGDG 1.2
el9.x86_64
PGDG 1.2
PGDG 1.2
PGDG 1.2
PGDG 1.2
PGDG 1.2
PGDG 1.2
el9.aarch64
PGDG 1.2
PGDG 1.2
PGDG 1.2
PGDG 1.2
PGDG 1.2
PGDG 1.2
el10.x86_64
PGDG 1.2
PGDG 1.2
PGDG 1.2
PGDG 1.2
PGDG 1.2
PGDG 1.2
el10.aarch64
PGDG 1.2
PGDG 1.2
PGDG 1.2
PGDG 1.2
PGDG 1.2
PGDG 1.2
d12.x86_64
PIGSTY 1.2
PIGSTY 1.2
PIGSTY 1.2
PIGSTY 1.2
PIGSTY 1.2
PIGSTY 1.2
d12.aarch64
PIGSTY 1.2
PIGSTY 1.2
PIGSTY 1.2
PIGSTY 1.2
PIGSTY 1.2
PIGSTY 1.2
d13.x86_64
PIGSTY 1.2
PIGSTY 1.2
PIGSTY 1.2
PIGSTY 1.2
PIGSTY 1.2
PIGSTY 1.2
d13.aarch64
PIGSTY 1.2
PIGSTY 1.2
PIGSTY 1.2
PIGSTY 1.2
PIGSTY 1.2
PIGSTY 1.2
u22.x86_64
PIGSTY 1.2
PIGSTY 1.2
PIGSTY 1.2
PIGSTY 1.2
PIGSTY 1.2
PIGSTY 1.2
u22.aarch64
PIGSTY 1.2
PIGSTY 1.2
PIGSTY 1.2
PIGSTY 1.2
PIGSTY 1.2
PIGSTY 1.2
u24.x86_64
PIGSTY 1.2
PIGSTY 1.2
PIGSTY 1.2
PIGSTY 1.2
PIGSTY 1.2
PIGSTY 1.2
u24.aarch64
PIGSTY 1.2
PIGSTY 1.2
PIGSTY 1.2
PIGSTY 1.2
PIGSTY 1.2
PIGSTY 1.2
PackageVersionOSORGSIZEFile URL
pg_bigm_171.2el8.x86_64pgdg20.4 KiBpg_bigm_17-1.2_20250903-1PGDG.rhel8.x86_64.rpm
pg_bigm_171.2el8.x86_64pgdg18.5 KiBpg_bigm_17-1.2_20240606-2PGDG.rhel8.x86_64.rpm
pg_bigm_171.2el8.aarch64pgdg20.1 KiBpg_bigm_17-1.2_20250903-1PGDG.rhel8.aarch64.rpm
pg_bigm_171.2el8.aarch64pgdg18.3 KiBpg_bigm_17-1.2_20240606-2PGDG.rhel8.aarch64.rpm
pg_bigm_171.2el9.x86_64pgdg18.9 KiBpg_bigm_17-1.2_20240606-2PGDG.rhel9.x86_64.rpm
pg_bigm_171.2el9.x86_64pgdg20.8 KiBpg_bigm_17-1.2_20250903-1PGDG.rhel9.x86_64.rpm
pg_bigm_171.2el9.aarch64pgdg20.4 KiBpg_bigm_17-1.2_20250903-1PGDG.rhel9.aarch64.rpm
pg_bigm_171.2el9.aarch64pgdg18.6 KiBpg_bigm_17-1.2_20240606-2PGDG.rhel9.aarch64.rpm
pg_bigm_171.2el10.x86_64pigsty19.5 KiBpg_bigm_17-1.2-1PIGSTY.el10.x86_64.rpm
pg_bigm_171.2el10.x86_64pgdg21.4 KiBpg_bigm_17-1.2_20250903-1PGDG.rhel10.x86_64.rpm
pg_bigm_171.2el10.x86_64pgdg21.2 KiBpg_bigm_17-1.2_20240606-3PGDG.rhel10.x86_64.rpm
pg_bigm_171.2el10.aarch64pigsty19.7 KiBpg_bigm_17-1.2-1PIGSTY.el10.aarch64.rpm
pg_bigm_171.2el10.aarch64pgdg20.9 KiBpg_bigm_17-1.2_20240606-3PGDG.rhel10.aarch64.rpm
pg_bigm_171.2el10.aarch64pgdg21.1 KiBpg_bigm_17-1.2_20250903-1PGDG.rhel10.aarch64.rpm
postgresql-17-pg-bigm1.2d12.x86_64pigsty27.0 KiBpostgresql-17-pg-bigm_1.2-3PIGSTY~bookworm_amd64.deb
postgresql-17-pg-bigm1.2d12.aarch64pigsty26.8 KiBpostgresql-17-pg-bigm_1.2-3PIGSTY~bookworm_arm64.deb
postgresql-17-pg-bigm1.2d13.x86_64pigsty27.1 KiBpostgresql-17-pg-bigm_1.2-3PIGSTY~trixie_amd64.deb
postgresql-17-pg-bigm1.2d13.aarch64pigsty27.0 KiBpostgresql-17-pg-bigm_1.2-3PIGSTY~trixie_arm64.deb
postgresql-17-pg-bigm1.2u22.x86_64pigsty32.1 KiBpostgresql-17-pg-bigm_1.2-3PIGSTY~jammy_amd64.deb
postgresql-17-pg-bigm1.2u22.aarch64pigsty31.7 KiBpostgresql-17-pg-bigm_1.2-3PIGSTY~jammy_arm64.deb
postgresql-17-pg-bigm1.2u24.x86_64pigsty28.2 KiBpostgresql-17-pg-bigm_1.2-3PIGSTY~noble_amd64.deb
postgresql-17-pg-bigm1.2u24.aarch64pigsty28.2 KiBpostgresql-17-pg-bigm_1.2-3PIGSTY~noble_arm64.deb
PackageVersionOSORGSIZEFile URL
pg_bigm_161.2el8.x86_64pgdg20.4 KiBpg_bigm_16-1.2_20250903-1PGDG.rhel8.x86_64.rpm
pg_bigm_161.2el8.x86_64pgdg18.4 KiBpg_bigm_16-1.2_20240606-1PGDG.rhel8.x86_64.rpm
pg_bigm_161.2el8.x86_64pgdg18.2 KiBpg_bigm_16-1.2-1PGDG.rhel8.x86_64.rpm
pg_bigm_161.2el8.aarch64pgdg18.2 KiBpg_bigm_16-1.2_20240606-1PGDG.rhel8.aarch64.rpm
pg_bigm_161.2el8.aarch64pgdg18.0 KiBpg_bigm_16-1.2-1PGDG.rhel8.aarch64.rpm
pg_bigm_161.2el8.aarch64pgdg20.1 KiBpg_bigm_16-1.2_20250903-1PGDG.rhel8.aarch64.rpm
pg_bigm_161.2el9.x86_64pgdg20.8 KiBpg_bigm_16-1.2_20250903-1PGDG.rhel9.x86_64.rpm
pg_bigm_161.2el9.x86_64pgdg18.8 KiBpg_bigm_16-1.2_20240606-1PGDG.rhel9.x86_64.rpm
pg_bigm_161.2el9.x86_64pgdg18.4 KiBpg_bigm_16-1.2-1PGDG.rhel9.x86_64.rpm
pg_bigm_161.2el9.aarch64pgdg20.4 KiBpg_bigm_16-1.2_20250903-1PGDG.rhel9.aarch64.rpm
pg_bigm_161.2el9.aarch64pgdg18.1 KiBpg_bigm_16-1.2-1PGDG.rhel9.aarch64.rpm
pg_bigm_161.2el9.aarch64pgdg18.5 KiBpg_bigm_16-1.2_20240606-1PGDG.rhel9.aarch64.rpm
pg_bigm_161.2el10.x86_64pigsty19.5 KiBpg_bigm_16-1.2-1PIGSTY.el10.x86_64.rpm
pg_bigm_161.2el10.x86_64pgdg21.2 KiBpg_bigm_16-1.2_20240606-3PGDG.rhel10.x86_64.rpm
pg_bigm_161.2el10.x86_64pgdg21.4 KiBpg_bigm_16-1.2_20250903-1PGDG.rhel10.x86_64.rpm
pg_bigm_161.2el10.aarch64pigsty19.7 KiBpg_bigm_16-1.2-1PIGSTY.el10.aarch64.rpm
pg_bigm_161.2el10.aarch64pgdg21.0 KiBpg_bigm_16-1.2_20240606-3PGDG.rhel10.aarch64.rpm
pg_bigm_161.2el10.aarch64pgdg21.2 KiBpg_bigm_16-1.2_20250903-1PGDG.rhel10.aarch64.rpm
postgresql-16-pg-bigm1.2d12.x86_64pigsty26.9 KiBpostgresql-16-pg-bigm_1.2-3PIGSTY~bookworm_amd64.deb
postgresql-16-pg-bigm1.2d12.aarch64pigsty26.7 KiBpostgresql-16-pg-bigm_1.2-3PIGSTY~bookworm_arm64.deb
postgresql-16-pg-bigm1.2d13.x86_64pigsty27.1 KiBpostgresql-16-pg-bigm_1.2-3PIGSTY~trixie_amd64.deb
postgresql-16-pg-bigm1.2d13.aarch64pigsty27.0 KiBpostgresql-16-pg-bigm_1.2-3PIGSTY~trixie_arm64.deb
postgresql-16-pg-bigm1.2u22.x86_64pigsty32.0 KiBpostgresql-16-pg-bigm_1.2-3PIGSTY~jammy_amd64.deb
postgresql-16-pg-bigm1.2u22.aarch64pigsty31.7 KiBpostgresql-16-pg-bigm_1.2-3PIGSTY~jammy_arm64.deb
postgresql-16-pg-bigm1.2u24.x86_64pigsty28.2 KiBpostgresql-16-pg-bigm_1.2-3PIGSTY~noble_amd64.deb
postgresql-16-pg-bigm1.2u24.aarch64pigsty28.2 KiBpostgresql-16-pg-bigm_1.2-3PIGSTY~noble_arm64.deb
PackageVersionOSORGSIZEFile URL
pg_bigm_151.2el8.x86_64pgdg20.5 KiBpg_bigm_15-1.2_20250903-1PGDG.rhel8.x86_64.rpm
pg_bigm_151.2el8.x86_64pgdg18.4 KiBpg_bigm_15-1.2-1PGDG.rhel8.x86_64.rpm
pg_bigm_151.2el8.x86_64pgdg18.6 KiBpg_bigm_15-1.2_20240606-1PGDG.rhel8.x86_64.rpm
pg_bigm_151.2el8.aarch64pgdg18.3 KiBpg_bigm_15-1.2_20240606-1PGDG.rhel8.aarch64.rpm
pg_bigm_151.2el8.aarch64pgdg18.1 KiBpg_bigm_15-1.2-1PGDG.rhel8.aarch64.rpm
pg_bigm_151.2el8.aarch64pgdg20.3 KiBpg_bigm_15-1.2_20250903-1PGDG.rhel8.aarch64.rpm
pg_bigm_151.2el9.x86_64pgdg18.8 KiBpg_bigm_15-1.2_20240606-1PGDG.rhel9.x86_64.rpm
pg_bigm_151.2el9.x86_64pgdg18.5 KiBpg_bigm_15-1.2-1PGDG.rhel9.x86_64.rpm
pg_bigm_151.2el9.x86_64pgdg20.9 KiBpg_bigm_15-1.2_20250903-1PGDG.rhel9.x86_64.rpm
pg_bigm_151.2el9.aarch64pgdg18.1 KiBpg_bigm_15-1.2-1PGDG.rhel9.aarch64.rpm
pg_bigm_151.2el9.aarch64pgdg18.5 KiBpg_bigm_15-1.2_20240606-1PGDG.rhel9.aarch64.rpm
pg_bigm_151.2el9.aarch64pgdg20.5 KiBpg_bigm_15-1.2_20250903-1PGDG.rhel9.aarch64.rpm
pg_bigm_151.2el10.x86_64pigsty19.8 KiBpg_bigm_15-1.2-1PIGSTY.el10.x86_64.rpm
pg_bigm_151.2el10.x86_64pgdg21.7 KiBpg_bigm_15-1.2_20250903-1PGDG.rhel10.x86_64.rpm
pg_bigm_151.2el10.x86_64pgdg21.4 KiBpg_bigm_15-1.2_20240606-3PGDG.rhel10.x86_64.rpm
pg_bigm_151.2el10.aarch64pigsty19.8 KiBpg_bigm_15-1.2-1PIGSTY.el10.aarch64.rpm
pg_bigm_151.2el10.aarch64pgdg21.1 KiBpg_bigm_15-1.2_20240606-3PGDG.rhel10.aarch64.rpm
pg_bigm_151.2el10.aarch64pgdg21.4 KiBpg_bigm_15-1.2_20250903-1PGDG.rhel10.aarch64.rpm
postgresql-15-pg-bigm1.2d12.x86_64pigsty27.2 KiBpostgresql-15-pg-bigm_1.2-3PIGSTY~bookworm_amd64.deb
postgresql-15-pg-bigm1.2d12.aarch64pigsty26.9 KiBpostgresql-15-pg-bigm_1.2-3PIGSTY~bookworm_arm64.deb
postgresql-15-pg-bigm1.2d13.x86_64pigsty27.4 KiBpostgresql-15-pg-bigm_1.2-3PIGSTY~trixie_amd64.deb
postgresql-15-pg-bigm1.2d13.aarch64pigsty27.2 KiBpostgresql-15-pg-bigm_1.2-3PIGSTY~trixie_arm64.deb
postgresql-15-pg-bigm1.2u22.x86_64pigsty32.1 KiBpostgresql-15-pg-bigm_1.2-3PIGSTY~jammy_amd64.deb
postgresql-15-pg-bigm1.2u22.aarch64pigsty31.8 KiBpostgresql-15-pg-bigm_1.2-3PIGSTY~jammy_arm64.deb
postgresql-15-pg-bigm1.2u24.x86_64pigsty28.4 KiBpostgresql-15-pg-bigm_1.2-3PIGSTY~noble_amd64.deb
postgresql-15-pg-bigm1.2u24.aarch64pigsty28.3 KiBpostgresql-15-pg-bigm_1.2-3PIGSTY~noble_arm64.deb
PackageVersionOSORGSIZEFile URL
pg_bigm_141.2el8.x86_64pgdg18.4 KiBpg_bigm_14-1.2-1PGDG.rhel8.x86_64.rpm
pg_bigm_141.2el8.x86_64pgdg18.6 KiBpg_bigm_14-1.2_20240606-1PGDG.rhel8.x86_64.rpm
pg_bigm_141.2el8.x86_64pgdg20.5 KiBpg_bigm_14-1.2_20250903-1PGDG.rhel8.x86_64.rpm
pg_bigm_141.2el8.aarch64pgdg18.3 KiBpg_bigm_14-1.2_20240606-1PGDG.rhel8.aarch64.rpm
pg_bigm_141.2el8.aarch64pgdg18.1 KiBpg_bigm_14-1.2-1PGDG.rhel8.aarch64.rpm
pg_bigm_141.2el8.aarch64pgdg20.3 KiBpg_bigm_14-1.2_20250903-1PGDG.rhel8.aarch64.rpm
pg_bigm_141.2el9.x86_64pgdg18.8 KiBpg_bigm_14-1.2_20240606-1PGDG.rhel9.x86_64.rpm
pg_bigm_141.2el9.x86_64pgdg18.5 KiBpg_bigm_14-1.2-1PGDG.rhel9.x86_64.rpm
pg_bigm_141.2el9.x86_64pgdg20.9 KiBpg_bigm_14-1.2_20250903-1PGDG.rhel9.x86_64.rpm
pg_bigm_141.2el9.aarch64pgdg18.5 KiBpg_bigm_14-1.2_20240606-1PGDG.rhel9.aarch64.rpm
pg_bigm_141.2el9.aarch64pgdg20.5 KiBpg_bigm_14-1.2_20250903-1PGDG.rhel9.aarch64.rpm
pg_bigm_141.2el9.aarch64pgdg18.1 KiBpg_bigm_14-1.2-1PGDG.rhel9.aarch64.rpm
pg_bigm_141.2el10.x86_64pigsty19.8 KiBpg_bigm_14-1.2-1PIGSTY.el10.x86_64.rpm
pg_bigm_141.2el10.x86_64pgdg21.7 KiBpg_bigm_14-1.2_20250903-1PGDG.rhel10.x86_64.rpm
pg_bigm_141.2el10.x86_64pgdg21.4 KiBpg_bigm_14-1.2_20240606-3PGDG.rhel10.x86_64.rpm
pg_bigm_141.2el10.aarch64pigsty19.8 KiBpg_bigm_14-1.2-1PIGSTY.el10.aarch64.rpm
pg_bigm_141.2el10.aarch64pgdg21.4 KiBpg_bigm_14-1.2_20250903-1PGDG.rhel10.aarch64.rpm
pg_bigm_141.2el10.aarch64pgdg21.1 KiBpg_bigm_14-1.2_20240606-3PGDG.rhel10.aarch64.rpm
postgresql-14-pg-bigm1.2d12.x86_64pigsty27.2 KiBpostgresql-14-pg-bigm_1.2-3PIGSTY~bookworm_amd64.deb
postgresql-14-pg-bigm1.2d12.aarch64pigsty26.8 KiBpostgresql-14-pg-bigm_1.2-3PIGSTY~bookworm_arm64.deb
postgresql-14-pg-bigm1.2d13.x86_64pigsty27.4 KiBpostgresql-14-pg-bigm_1.2-3PIGSTY~trixie_amd64.deb
postgresql-14-pg-bigm1.2d13.aarch64pigsty27.1 KiBpostgresql-14-pg-bigm_1.2-3PIGSTY~trixie_arm64.deb
postgresql-14-pg-bigm1.2u22.x86_64pigsty31.9 KiBpostgresql-14-pg-bigm_1.2-3PIGSTY~jammy_amd64.deb
postgresql-14-pg-bigm1.2u22.aarch64pigsty31.7 KiBpostgresql-14-pg-bigm_1.2-3PIGSTY~jammy_arm64.deb
postgresql-14-pg-bigm1.2u24.x86_64pigsty28.3 KiBpostgresql-14-pg-bigm_1.2-3PIGSTY~noble_amd64.deb
postgresql-14-pg-bigm1.2u24.aarch64pigsty28.3 KiBpostgresql-14-pg-bigm_1.2-3PIGSTY~noble_arm64.deb
PackageVersionOSORGSIZEFile URL
pg_bigm_131.2el8.x86_64pgdg18.4 KiBpg_bigm_13-1.2_20240606-1PGDG.rhel8.x86_64.rpm
pg_bigm_131.2el8.x86_64pgdg18.2 KiBpg_bigm_13-1.2-1PGDG.rhel8.x86_64.rpm
pg_bigm_131.2el8.x86_64pgdg20.4 KiBpg_bigm_13-1.2_20250903-1PGDG.rhel8.x86_64.rpm
pg_bigm_131.2el8.aarch64pgdg18.3 KiBpg_bigm_13-1.2_20240606-1PGDG.rhel8.aarch64.rpm
pg_bigm_131.2el8.aarch64pgdg20.2 KiBpg_bigm_13-1.2_20250903-1PGDG.rhel8.aarch64.rpm
pg_bigm_131.2el8.aarch64pgdg18.1 KiBpg_bigm_13-1.2-1PGDG.rhel8.aarch64.rpm
pg_bigm_131.2el9.x86_64pgdg18.5 KiBpg_bigm_13-1.2-1PGDG.rhel9.x86_64.rpm
pg_bigm_131.2el9.x86_64pgdg18.8 KiBpg_bigm_13-1.2_20240606-1PGDG.rhel9.x86_64.rpm
pg_bigm_131.2el9.x86_64pgdg20.9 KiBpg_bigm_13-1.2_20250903-1PGDG.rhel9.x86_64.rpm
pg_bigm_131.2el9.aarch64pgdg18.6 KiBpg_bigm_13-1.2_20240606-1PGDG.rhel9.aarch64.rpm
pg_bigm_131.2el9.aarch64pgdg18.1 KiBpg_bigm_13-1.2-1PGDG.rhel9.aarch64.rpm
pg_bigm_131.2el9.aarch64pgdg20.5 KiBpg_bigm_13-1.2_20250903-1PGDG.rhel9.aarch64.rpm
pg_bigm_131.2el10.x86_64pigsty19.8 KiBpg_bigm_13-1.2-1PIGSTY.el10.x86_64.rpm
pg_bigm_131.2el10.x86_64pgdg21.4 KiBpg_bigm_13-1.2_20240606-3PGDG.rhel10.x86_64.rpm
pg_bigm_131.2el10.x86_64pgdg21.7 KiBpg_bigm_13-1.2_20250903-1PGDG.rhel10.x86_64.rpm
pg_bigm_131.2el10.aarch64pigsty19.8 KiBpg_bigm_13-1.2-1PIGSTY.el10.aarch64.rpm
pg_bigm_131.2el10.aarch64pgdg21.1 KiBpg_bigm_13-1.2_20240606-3PGDG.rhel10.aarch64.rpm
pg_bigm_131.2el10.aarch64pgdg21.4 KiBpg_bigm_13-1.2_20250903-1PGDG.rhel10.aarch64.rpm
postgresql-13-pg-bigm1.2d12.x86_64pigsty26.8 KiBpostgresql-13-pg-bigm_1.2-3PIGSTY~bookworm_amd64.deb
postgresql-13-pg-bigm1.2d12.aarch64pigsty26.6 KiBpostgresql-13-pg-bigm_1.2-3PIGSTY~bookworm_arm64.deb
postgresql-13-pg-bigm1.2d13.x86_64pigsty27.1 KiBpostgresql-13-pg-bigm_1.2-3PIGSTY~trixie_amd64.deb
postgresql-13-pg-bigm1.2d13.aarch64pigsty26.9 KiBpostgresql-13-pg-bigm_1.2-3PIGSTY~trixie_arm64.deb
postgresql-13-pg-bigm1.2u22.x86_64pigsty31.6 KiBpostgresql-13-pg-bigm_1.2-3PIGSTY~jammy_amd64.deb
postgresql-13-pg-bigm1.2u22.aarch64pigsty31.4 KiBpostgresql-13-pg-bigm_1.2-3PIGSTY~jammy_arm64.deb
postgresql-13-pg-bigm1.2u24.x86_64pigsty28.0 KiBpostgresql-13-pg-bigm_1.2-3PIGSTY~noble_amd64.deb
postgresql-13-pg-bigm1.2u24.aarch64pigsty28.0 KiBpostgresql-13-pg-bigm_1.2-3PIGSTY~noble_arm64.deb

Source

pig build pkg pg_bigm;		# build spec not ready

Install

Make sure PGDG and PIGSTY repo available:

pig repo add pgdg pigsty -u   # add both repo and update cache

Install this extension with pig:

pig install pg_bigm;		# install via package name, for the active PG version

pig install pg_bigm -v 18;   # install for PG 18
pig install pg_bigm -v 17;   # install for PG 17
pig install pg_bigm -v 16;   # install for PG 16
pig install pg_bigm -v 15;   # install for PG 15
pig install pg_bigm -v 14;   # install for PG 14
pig install pg_bigm -v 13;   # install for PG 13

Create this extension with:

CREATE EXTENSION pg_bigm;
Last updated on