pgroonga_database

Overview

Version

Build

You can build the RPM / DEB packages for pgroonga using pig build:

pig build pkg pgroonga         # build RPM / DEB packages

Install

You can install pgroonga directly. First, make sure the PGDG and PIGSTY repositories are added and enabled:

pig repo add pgsql -u          # Add repo and update cache

Install the extension using pig or apt/yum/dnf:

pig install pgroonga;          # Install for current active PG version

pig ext install -y pgroonga -v 18  # PG 18
pig ext install -y pgroonga -v 17  # PG 17
pig ext install -y pgroonga -v 16  # PG 16
pig ext install -y pgroonga -v 15  # PG 15
pig ext install -y pgroonga -v 14  # PG 14

dnf install -y pgroonga_18       # PG 18
dnf install -y pgroonga_17       # PG 17
dnf install -y pgroonga_16       # PG 16
dnf install -y pgroonga_15       # PG 15
dnf install -y pgroonga_14       # PG 14

apt install -y postgresql-18-pgroonga   # PG 18
apt install -y postgresql-17-pgroonga   # PG 17
apt install -y postgresql-16-pgroonga   # PG 16
apt install -y postgresql-15-pgroonga   # PG 15
apt install -y postgresql-14-pgroonga   # PG 14

Create Extension:

CREATE EXTENSION pgroonga_database;

Usage

PGroonga Documentation | GitHub: pgroonga/pgroonga

pgroonga_database is a sub-extension of the PGroonga project. It provides database management functionality for PGroonga, which makes PostgreSQL a fast full text search platform for all languages.

PGroonga is a comprehensive full text search solution that uses Groonga as a backend. It supports all languages including CJK (Chinese, Japanese, Korean) out of the box, and provides rich features such as:

• Fast full text search with all language support
• Rich query syntax (query language, script syntax)
• JSON search
• HTML/XML tag aware highlighting
• Similar search
• Synonym expansion
• Autocomplete
• Query log analysis

The PGroonga documentation is extensive and spans hundreds of pages. For detailed usage, API reference, operators, functions, and tuning guides, please refer to the official documentation site:

• PGroonga Official Documentation
• Getting Started
• Tutorial
• How-to Guides
• Reference

Quick Start

CREATE EXTENSION pgroonga_database;
CREATE EXTENSION pgroonga;

-- Create a table with text content
CREATE TABLE memos (
  id integer,
  content text
);

-- Create a PGroonga index
CREATE INDEX pgroonga_content_index ON memos USING pgroonga (content);

-- Insert data
INSERT INTO memos VALUES (1, 'PostgreSQL is a relational database management system.');
INSERT INTO memos VALUES (2, 'Groonga is a fast full text search engine that supports all languages.');
INSERT INTO memos VALUES (3, 'PGroonga is a PostgreSQL extension that uses Groonga as its backend.');

-- Full text search
SELECT * FROM memos WHERE content &@~ 'PostgreSQL OR Groonga';