pg_bigm

The pg_bigm module provides full text search capability in PostgreSQL. This module allows a user to create 2-gram (bigram) index for faster full text search.

News

2023-02-17: The RPM files of pg_bigm 1.2-20200228 on PostgreSQL 11 to 15 for RHEL 9 family were released. They can be downloaded from here.
2022-10-24: The RPM files of pg_bigm 1.2-20200228 for PostgreSQL 15 were released. They can be downloaded from here.
2022-10-13: pg_bigm 1.2 was confirmed to work with PostgreSQL 15.
2021-10-07: The RPM files of pg_bigm 1.2-20200228 for PostgreSQL 14 were released. They can be downloaded from here.
2021-09-30: pg_bigm 1.2 was confirmed to work with PostgreSQL 14.
2020-11-17: The RPM files of pg_bigm 1.2-20200228 for PostgreSQL 13 were released. They can be downloaded from here.
2020-11-05: pg_bigm 1.2 was confirmed to work with PostgreSQL 13.
2020-04-01: The RPM files of pg_bigm 1.2-20200228 for PostgreSQL 9.4 to 12 were released. They can be downloaded from here.
2020-02-28: The latest minor version of pg_bigm 1.2, pg_bigm-1.2-20200228 was released.(Release Note)
2020-02-28: The latest minor version of pg_bigm 1.1, pg_bigm-1.1-20200228 was released.(Release Note)
2019-10-03: The latest minor version of pg_bigm 1.2, pg_bigm-1.2-20191003 was released. (Release Note)
2018-11-07: pg_bigm 1.2 and 1.1 were confirmed to work with PostgreSQL 11.
2017-10-06: pg_bigm 1.2 and 1.1 were confirmed to work with PostgreSQL 10.
2016-10-21: The RPM files of pg_bigm 1.2-20161011 for PostgreSQL 9.1 to 9.6 were released. They can be downloaded from here.
2016-10-11: pg_bigm 1.2, the latest major version pg_bigm-1.2-20161011 was released. (Release Note)
2016-10-11: The latest minor version of pg_bigm 1.1, pg_bigm-1.1-20161011 was released.(Release Note)
2016-01-15: The RPM files of pg_bigm 1.1-20150910 for PostgreSQL 9.1 to 9.5 were released. They can be downloaded from here.
2016-01-13: pg_bigm 1.1 was confirmed to work with PostgreSQL9.5.
2015-09-10: The latest minor version of pg_bigm 1.1, pg_bigm-1.1-20150910 was released.(Release Note)
2015-09-10: The latest minor version of pg_bigm 1.0, pg_bigm-1.0-20150910 was released.(Release Note)
2015-03-09: Limitations section was added into document of pg_bigm 1.1.
2015-02-05: The RPM file of pg_bigm 1.1 for PostgreSQL 9.4 was released. It can be downloaded from here.
2014-12-19: pg_bigm 1.1 was confirmed to work with PostgreSQL9.4.
2013-12-20: The RPM files of pg_bigm 1.1 for PostgreSQL 9.1, 9.2, 9.3 were released. They can be downloaded from here.
2013-11-22: pg_bigm 1.1, the latest major version pg_bigm-1.1-20131122 was released. (Release Note)
2013-11-22: The latest minor version of pg_bigm 1.0, pg_bigm-1.0-20131122 was released. (Release Note)
2013-10-05: Sawada from NTT DATA gave a great talk about the performance comparison of pg_bigm and pg_trgm at PostgreSQL Shikumi meet-up. Here is the slide presentation from that talk.
2013-06-08: Sawada from NTT DATA gave a great talk about the architecture of pg_bigm at PostgreSQL Shikumi meet-up. Here is the slide presentation from that talk.
2013-04-05: pg_bigm-20130405 was released.

Document

Community

general discussion: This is a forum where all topics related to pg_bigm (bug report, technical information etc.) are discussed.

pgbigm-hackers: This is the mailing list for pg_bigm developers.

Development

The pg_bigm source code is now maintained in a git repository available here.