Hi, PGroonga 1.1.1 has been released!
http://groonga.org/en/blog/2016/08/31/pgroonga-1.1.1.html ### About PGroonga https://pgroonga.github.io/ PGroonga is a PostgreSQL extension that makes PostgreSQL fast full text search platform for all languages! It's released under PostgreSQL license. There are some PostgreSQL extensions that improves full text search feature of PostgreSQL such as pg_trgm(*1). (*1) http://www.postgresql.org/docs/current/static/pgtrgm.html pg_trgm doesn't support languages that use non-alphanumerics characters such as Japanese and Chinese. PGroonga supports all languages, provides rich full text search related features and is very fast. Because PGroonga uses Groonga(*2) that is a full-fledged full text search engine as backend. (*2) http://groonga.org/ PGroonga also supports JSON search. You can use each value for condition. You can also perform full text search against all texts in JSON. No other extension such as JsQuery(*3) doesn't provide full text search feature against JSON. (*3) https://github.com/postgrespro/jsquery ### Changes In this release, performance improvement is major improvement. You can get more performance by just upgrading to 1.1.1. Here are changes since 1.0.9: * Improved the number of hits estimation. It helps that planner choose suitable index use or not index use. Therefore, total performance is improved. * Fixed a bug that needless recheck is ran on bitmap heap scan. If recheck is ran, performance is down. * Added pgroonga.match_positions_character function that returns match positions in character. https://pgroonga.github.io/reference/functions/pgroonga-match-positions-character.html * Added pgroonga.flush function that flushes buffered changes in memory. https://pgroonga.github.io/reference/functions/pgroonga-flush.html ### New users Zulip, open source group chat application by Dropbox, starts supporting full text search for all languages. It's based on PGroonga. Zulip used built-in full text search feature. So Zulip supports only one language (English) at the same time. PGroonga can support all languages at the same. Zulip: https://zulip.org/ If you're a PGroonga user, please tell your use case: https://pgroonga.github.io/users/ ### Usage You can use PGroonga without full text search knowledge. You just create an index and puts a condition into WHERE: CREATE INDEX index_name ON table USING pgroonga (column); SELECT * FROM table WHERE column @@ 'PostgreSQL'; You can also use LIKE to use PGroonga. PGroonga provides a feature that performs LIKE with index. LIKE with PGroonga index is faster than LIKE without index. It means that you can improve performance without changing your application that uses the following SQL: SELECT * FROM table WHERE column LIKE '%PostgreSQL%'; Are you interested in PGroonga? Please install(*4) and try tutorial(*5). You can know all PGroonga features. (*4) https://pgroonga.github.io/install/ (*5) https://pgroonga.github.io/tutorial/ You can install PGroonga easily. Because PGroonga provides packages for major platforms. There are binaries for Windows. Thanks, -- kou -- Sent via pgsql-announce mailing list (pgsql-announce@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-announce