Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sx23B-007SRz-TK for pgsql-announce@arkaria.postgresql.org; Sat, 05 Oct 2024 10:30:15 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1sx23A-00FdXE-S2 for pgsql-announce@arkaria.postgresql.org; Sat, 05 Oct 2024 10:30:12 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sx239-00FdTu-Ot for pgsql-announce@lists.postgresql.org; Sat, 05 Oct 2024 10:30:12 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sx236-002b13-8x for pgsql-announce@lists.postgresql.org; Sat, 05 Oct 2024 10:30:10 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Message-ID:Date:Reply-To:From:To:Subject: MIME-Version:Content-Type:Sender:Cc:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=XhEaZ7jKn2QkKOHPCoSUvfoCXEqpldXICXaO0AEvIjY=; b=6AcYkYy/vdvAhZSXcbrqXFg1zy WwwOhcsLMf+oufPNgrb6S3agzIEkLDXltQRrfuz/XcVPvnDOXtwD7veSTmX+1zVxqZBFGU+E7RmFZ M1sd4fCNlMyQUoCVqhPF7OvBRKOzo8BlWzLXxprDoc9xNznMInpiUjUboYRlG1yRl3cKecIRPAbN2 zekrBqOTc1a5mEqctssi4csus6wyRPhjp1MIkShdpegczvZrnC+yYklizZTWxoEX9OdhCKdfEHaYj N5O6rqt3+Bj8dFw1iHZ0gj5MtJ3D6fi2+Ke1FJ93xYf+IXeDaXlQS+j18D51BU9pbXAKvXfCC4UmE NhHFvLXA==; Received: from wrigleys.postgresql.org ([2a02:16a8:dc51::60]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sx234-008A26-11 for pgsql-announce@lists.postgresql.org; Sat, 05 Oct 2024 10:30:07 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1sx232-00FFL3-Fj for pgsql-announce@lists.postgresql.org; Sat, 05 Oct 2024 10:30:04 +0000 Content-Type: multipart/mixed; boundary="===============3248111134253681739==" MIME-Version: 1.0 Subject: PGroonga 3.2.4 - Multilingual fast full text search To: PostgreSQL Announce From: PGroonga project via PostgreSQL Announce Reply-To: horimoto@clear-code.com Date: Sat, 05 Oct 2024 10:29:10 +0000 Message-ID: <172812415035.689.8036401142056512543@wrigleys.postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated X-pglister-tags: related X-pglister-tagsig: d0535bd6e68c25b383c20c4944ac7636deb79ac111afbfea0497fdc05d785eb4 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============3248111134253681739== Content-Type: multipart/alternative; boundary="===============3079323967067126901==" MIME-Version: 1.0 --===============3079323967067126901== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable Hi, PGroonga 3.2.4 has been released! This release adds support for PostgreSQL 17! We can use PGroonga with PostgreSQL 17 on the below OSes now! * AlmaLinux 8 * AlmaLinux 9 * Debian 12 (bookworm) * Ubuntu 20.04 (Focal Fossa) * Ubuntu 22.04 (Jammy Jellyfish) * Ubuntu 24.04 (Noble Numbat) * macOS * Microsoft Windows ### About PGroonga [https://pgroonga.github.io/](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) https://www.postgresql.org/docs/current/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) https://groonga.org/ See the following benchmark results for performance: * Benchmark result for PGroonga, textsearch and pg_trgm with English Wiki= pedia - https://pgroonga.github.io/reference/pgroonga-versus-textsearch-and= -pg-trgm.html * Benchmark result for PGroonga and pg_bigm with Japanese Wikipedia - htt= ps://pgroonga.github.io/reference/pgroonga-versus-pg-bigm.html PGroonga also supports JSON search. You can use each value for condition. You can also perform full text search against all texts in JSON like textsearch in PostgreSQL 10 does. ### Users Here are PGroonga users: * 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, --===============3079323967067126901== Content-Type: text/html; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable PGroonga 3.2.4 - Multilingual fast full text search
 

PGroonga 3.2.4 - Multilingual fast full text search

Hi,

PGroonga 3.2.4 has been released!

This release adds support for PostgreSQL 17= !

We can use PGroonga with PostgreSQL 17 on t= he below OSes now!

  • AlmaLinux 8
  • AlmaLinux 9
  • Debian 12 (book= worm)
  • Ubuntu 20.04 (F= ocal Fossa)
  • Ubuntu 22.04 (J= ammy Jellyfish)
  • Ubuntu 24.04 (N= oble Numbat)
  • macOS
  • Microsoft Windo= ws

About PGroonga

https://pgroonga.github.i= o/

PGroonga is a PostgreSQL extension that mak= es PostgreSQL fast full text search platform for all languages! It's released under PostgreSQL license.

There are some PostgreSQL extensions that i= mproves full text search feature of PostgreSQL such as pg_trgm(*1).

(*1) https://www.postgresql.org/docs/curren= t/pgtrgm.html

pg_trgm doesn't support languages that use = non-alphanumerics characters such as Japanese and Chinese.

PGroonga supports all languages, provides r= ich 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) https://groonga.org/

See the following benchmark results for per= formance:

  • Benchmark resul= t for PGroonga, textsearch and pg_trgm with English Wikipedia - https://pgr= oonga.github.io/reference/pgroonga-versus-textsearch-and-pg-trgm.html
  • Benchmark resul= t for PGroonga and pg_bigm with Japanese Wikipedia - https://pgroonga.githu= b.io/reference/pgroonga-versus-pg-bigm.html

PGroonga also supports JSON search. You can= use each value for condition. You can also perform full text search against all texts in JSON like textsearch in PostgreSQL 10 does.

Users

Here are PGroonga users:

  • https://pgroong= a.github.io/users/

Usage

You can use PGroonga without full text sear= ch knowledge. You just create an index and puts a condition into WHERE:

CREATE INDEX index_name ON table USIN= G pgroonga (column);

SELECT * FROM table WHERE column &= ;@~ 'PostgreSQL';

You can also use LIKE to use PGroonga. PGro= onga 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 inst= all(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 PG= roonga provides packages for major platforms. There are binaries for Windows.

Thanks,
This email was sent to you from PGroonga project. It was delivered on their= behalf by the PostgreSQL project. Any questions about the content of the message shou= ld be sent to PGroonga project.

You were sent this email as a subscriber of the pgsql-announce mai= linglist, for the content tag Related Open Source. To unsubscribe from further emails, or change which emails you want to receive, please click th= e personal unsubscribe link that you can find in the headers of this email, or visit https://lists.postgresql.org/unsubscribe/.
 
--===============3079323967067126901==-- --===============3248111134253681739==--