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 AvailabilityPackage PatternDependencies
EL
PGDG
1.2
18
17
16
15
14
13
pg_bigm_$v*-
Debian
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
MISS
PIGSTY 1.2
PIGSTY 1.2
PIGSTY 1.2
PIGSTY 1.2
PIGSTY 1.2
d12.aarch64
MISS
PIGSTY 1.2
PIGSTY 1.2
PIGSTY 1.2
PIGSTY 1.2
PIGSTY 1.2
d13.x86_64
MISS
MISS
MISS
MISS
MISS
MISS
d13.aarch64
MISS
MISS
MISS
MISS
MISS
MISS
u22.x86_64
MISS
PIGSTY 1.2
PIGSTY 1.2
PIGSTY 1.2
PIGSTY 1.2
PIGSTY 1.2
u22.aarch64
MISS
PIGSTY 1.2
PIGSTY 1.2
PIGSTY 1.2
PIGSTY 1.2
PIGSTY 1.2
u24.x86_64
MISS
PIGSTY 1.2
PIGSTY 1.2
PIGSTY 1.2
PIGSTY 1.2
PIGSTY 1.2
u24.aarch64
MISS
PIGSTY 1.2
PIGSTY 1.2
PIGSTY 1.2
PIGSTY 1.2
PIGSTY 1.2
PackageVersionOSORGSIZEFile URL
pg_bigm_181.2el8.x86_64pgdg20.6 KiBpg_bigm_18-1.2_20250903-1PGDG.rhel8.x86_64.rpm
pg_bigm_181.2el8.aarch64pgdg20.3 KiBpg_bigm_18-1.2_20250903-1PGDG.rhel8.aarch64.rpm
pg_bigm_181.2el9.x86_64pgdg21.0 KiBpg_bigm_18-1.2_20250903-1PGDG.rhel9.x86_64.rpm
pg_bigm_181.2el9.aarch64pgdg20.5 KiBpg_bigm_18-1.2_20250903-1PGDG.rhel9.aarch64.rpm
pg_bigm_181.2el10.x86_64pgdg21.6 KiBpg_bigm_18-1.2_20250903-1PGDG.rhel10.x86_64.rpm
pg_bigm_181.2el10.aarch64pgdg21.3 KiBpg_bigm_18-1.2_20250903-1PGDG.rhel10.aarch64.rpm
PackageVersionOSORGSIZEFile URL
pg_bigm_171.2el8.x86_64pgdg18.5 KiBpg_bigm_17-1.2_20240606-2PGDG.rhel8.x86_64.rpm
pg_bigm_171.2el8.x86_64pgdg20.4 KiBpg_bigm_17-1.2_20250903-1PGDG.rhel8.x86_64.rpm
pg_bigm_171.2el8.aarch64pgdg18.3 KiBpg_bigm_17-1.2_20240606-2PGDG.rhel8.aarch64.rpm
pg_bigm_171.2el8.aarch64pgdg20.1 KiBpg_bigm_17-1.2_20250903-1PGDG.rhel8.aarch64.rpm
pg_bigm_171.2el9.x86_64pgdg20.8 KiBpg_bigm_17-1.2_20250903-1PGDG.rhel9.x86_64.rpm
pg_bigm_171.2el9.x86_64pgdg18.9 KiBpg_bigm_17-1.2_20240606-2PGDG.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_64pigsty30.6 KiBpostgresql-17-pg-bigm_1.2-1PIGSTY~bookworm_amd64.deb
postgresql-17-pg-bigm1.2d12.aarch64pigsty30.1 KiBpostgresql-17-pg-bigm_1.2-1PIGSTY~bookworm_arm64.deb
postgresql-17-pg-bigm1.2u22.x86_64pigsty31.8 KiBpostgresql-17-pg-bigm_1.2-1PIGSTY~jammy_amd64.deb
postgresql-17-pg-bigm1.2u22.aarch64pigsty31.4 KiBpostgresql-17-pg-bigm_1.2-1PIGSTY~jammy_arm64.deb
postgresql-17-pg-bigm1.2u24.x86_64pigsty28.3 KiBpostgresql-17-pg-bigm_1.2-1PIGSTY~noble_amd64.deb
postgresql-17-pg-bigm1.2u24.aarch64pigsty28.1 KiBpostgresql-17-pg-bigm_1.2-1PIGSTY~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.2 KiBpg_bigm_16-1.2-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.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_64pgdg18.8 KiBpg_bigm_16-1.2_20240606-1PGDG.rhel9.x86_64.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.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.4 KiBpg_bigm_16-1.2_20250903-1PGDG.rhel10.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.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_64pigsty30.5 KiBpostgresql-16-pg-bigm_1.2-1PIGSTY~bookworm_amd64.deb
postgresql-16-pg-bigm1.2d12.aarch64pigsty30.0 KiBpostgresql-16-pg-bigm_1.2-1PIGSTY~bookworm_arm64.deb
postgresql-16-pg-bigm1.2u22.x86_64pigsty31.7 KiBpostgresql-16-pg-bigm_1.2-1PIGSTY~jammy_amd64.deb
postgresql-16-pg-bigm1.2u22.aarch64pigsty31.3 KiBpostgresql-16-pg-bigm_1.2-1PIGSTY~jammy_arm64.deb
postgresql-16-pg-bigm1.2u24.x86_64pigsty28.3 KiBpostgresql-16-pg-bigm_1.2-1PIGSTY~noble_amd64.deb
postgresql-16-pg-bigm1.2u24.aarch64pigsty28.1 KiBpostgresql-16-pg-bigm_1.2-1PIGSTY~noble_arm64.deb
PackageVersionOSORGSIZEFile URL
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.x86_64pgdg20.5 KiBpg_bigm_15-1.2_20250903-1PGDG.rhel8.x86_64.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.2el8.aarch64pgdg18.3 KiBpg_bigm_15-1.2_20240606-1PGDG.rhel8.aarch64.rpm
pg_bigm_151.2el9.x86_64pgdg18.5 KiBpg_bigm_15-1.2-1PGDG.rhel9.x86_64.rpm
pg_bigm_151.2el9.x86_64pgdg18.8 KiBpg_bigm_15-1.2_20240606-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.aarch64pgdg20.5 KiBpg_bigm_15-1.2_20250903-1PGDG.rhel9.aarch64.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.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_64pigsty30.6 KiBpostgresql-15-pg-bigm_1.2-1PIGSTY~bookworm_amd64.deb
postgresql-15-pg-bigm1.2d12.aarch64pigsty30.2 KiBpostgresql-15-pg-bigm_1.2-1PIGSTY~bookworm_arm64.deb
postgresql-15-pg-bigm1.2u22.x86_64pigsty31.7 KiBpostgresql-15-pg-bigm_1.2-1PIGSTY~jammy_amd64.deb
postgresql-15-pg-bigm1.2u22.aarch64pigsty31.4 KiBpostgresql-15-pg-bigm_1.2-1PIGSTY~jammy_arm64.deb
postgresql-15-pg-bigm1.2u24.x86_64pigsty28.4 KiBpostgresql-15-pg-bigm_1.2-1PIGSTY~noble_amd64.deb
postgresql-15-pg-bigm1.2u24.aarch64pigsty28.2 KiBpostgresql-15-pg-bigm_1.2-1PIGSTY~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_64pgdg20.5 KiBpg_bigm_14-1.2_20250903-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.aarch64pgdg18.3 KiBpg_bigm_14-1.2_20240606-1PGDG.rhel8.aarch64.rpm
pg_bigm_141.2el8.aarch64pgdg20.3 KiBpg_bigm_14-1.2_20250903-1PGDG.rhel8.aarch64.rpm
pg_bigm_141.2el8.aarch64pgdg18.1 KiBpg_bigm_14-1.2-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_64pgdg20.9 KiBpg_bigm_14-1.2_20250903-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.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.1 KiBpg_bigm_14-1.2_20240606-3PGDG.rhel10.aarch64.rpm
pg_bigm_141.2el10.aarch64pgdg21.4 KiBpg_bigm_14-1.2_20250903-1PGDG.rhel10.aarch64.rpm
postgresql-14-pg-bigm1.2d12.x86_64pigsty30.5 KiBpostgresql-14-pg-bigm_1.2-1PIGSTY~bookworm_amd64.deb
postgresql-14-pg-bigm1.2d12.aarch64pigsty30.1 KiBpostgresql-14-pg-bigm_1.2-1PIGSTY~bookworm_arm64.deb
postgresql-14-pg-bigm1.2u22.x86_64pigsty31.6 KiBpostgresql-14-pg-bigm_1.2-1PIGSTY~jammy_amd64.deb
postgresql-14-pg-bigm1.2u22.aarch64pigsty31.3 KiBpostgresql-14-pg-bigm_1.2-1PIGSTY~jammy_arm64.deb
postgresql-14-pg-bigm1.2u24.x86_64pigsty28.4 KiBpostgresql-14-pg-bigm_1.2-1PIGSTY~noble_amd64.deb
postgresql-14-pg-bigm1.2u24.aarch64pigsty28.2 KiBpostgresql-14-pg-bigm_1.2-1PIGSTY~noble_arm64.deb
PackageVersionOSORGSIZEFile URL
pg_bigm_131.2el8.x86_64pgdg20.4 KiBpg_bigm_13-1.2_20250903-1PGDG.rhel8.x86_64.rpm
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.aarch64pgdg18.3 KiBpg_bigm_13-1.2_20240606-1PGDG.rhel8.aarch64.rpm
pg_bigm_131.2el8.aarch64pgdg18.1 KiBpg_bigm_13-1.2-1PGDG.rhel8.aarch64.rpm
pg_bigm_131.2el8.aarch64pgdg20.2 KiBpg_bigm_13-1.2_20250903-1PGDG.rhel8.aarch64.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.x86_64pgdg18.5 KiBpg_bigm_13-1.2-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.7 KiBpg_bigm_13-1.2_20250903-1PGDG.rhel10.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.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_64pigsty30.2 KiBpostgresql-13-pg-bigm_1.2-1PIGSTY~bookworm_amd64.deb
postgresql-13-pg-bigm1.2d12.aarch64pigsty29.8 KiBpostgresql-13-pg-bigm_1.2-1PIGSTY~bookworm_arm64.deb
postgresql-13-pg-bigm1.2u22.x86_64pigsty31.2 KiBpostgresql-13-pg-bigm_1.2-1PIGSTY~jammy_amd64.deb
postgresql-13-pg-bigm1.2u22.aarch64pigsty31.0 KiBpostgresql-13-pg-bigm_1.2-1PIGSTY~jammy_arm64.deb
postgresql-13-pg-bigm1.2u24.x86_64pigsty28.1 KiBpostgresql-13-pg-bigm_1.2-1PIGSTY~noble_amd64.deb
postgresql-13-pg-bigm1.2u24.aarch64pigsty28.0 KiBpostgresql-13-pg-bigm_1.2-1PIGSTY~noble_arm64.deb

Source

pig build get pg_bigm; # get pg_bigm source code
pig build dep pg_bigm; # install build dependencies
pig build pkg pg_bigm; # build extension rpm or deb
pig build ext pg_bigm; # build extension rpms

Install

To add the required PGDG / PIGSTY upstream repository, use:

pig repo add pgsql -u   # add PGDG + Pigsty repo and update cache (leave existing repos)

Install this extension with:

pig ext install pg_bigm; # install by extension name, for the current active PG version
pig ext install pg_bigm; # install via package alias, for the active PG version
pig ext install pg_bigm -v 18;   # install for PG 18
pig ext install pg_bigm -v 17;   # install for PG 17
pig ext install pg_bigm -v 16;   # install for PG 16
pig ext install pg_bigm -v 15;   # install for PG 15
pig ext install pg_bigm -v 14;   # install for PG 14
pig ext install pg_bigm -v 13;   # install for PG 13

Create this extension with:

CREATE EXTENSION pg_bigm;
Last updated on