Reference manual

This document describes about all features. Tutorial focuses on easy to understand only about important features. This document focuses on completeness. If you don't read tutorial yet, read tutorial before read this document.

pgroonga schema

PGroonga defines functions, operators, operator classes and so on into pgroonga schema. Only superuser can use features in pgroonga schema by default. Superuser needs to grant USAGE privilege on pgroonga schema to normal users who want to use PGroonga.

pgroonga index

Operators

For text

By the default operator class:

By pgroonga.text_regexp_ops operator class:

For text[]

For varchar

By the default operator class:

By pgroonga.varchar_full_text_search_ops operator class:

By pgroonga.varchar_regexp_ops operator class:

For varchar[]

For boolean, numbers and timestamps

Supported types: boolean, smallint, integer, bigint, real, double precision, timestamp and timestamp with time zone

For jsonb

Operators v2

PGroonga 1.Y.Z provides pgroonga.XXX_v2 operator classes. They don't provide backward compatibility until PGroonga 2.0.0. But they include many improvements aggressively when new versions are released.

If you use them, you need to use incompatible case steps to upgrade PGroonga.

For text

By pgroonga.text_full_text_search_ops_v2 operator class:

By pgroonga.text_term_search_ops_v2 operator class:

By pgroonga.text_regexp_ops_v2 operator class:

For text[]

By pgroonga.text_full_text_search_ops_v2 operator class:

By pgroonga.text_array_term_search_ops_v2 operator class

For varchar

By pgroonga.varchar_full_text_search_ops_v2 operator class:

By pgroonga.varchar_regexp_ops_v2 operator class:

For varchar[]

By pgroonga.varchar_array_ops_v2 operator class:

For jsonb

By pgroonga.jsonb_ops_v2 operator class:

Functions

Parameters

Modules

Groonga functions

You can use them with pgroonga.command function. You can't use them in WHERE clause.

Tuning

Normally, you don't need to tune PGroonga because PGroonga works well by default.

But you need to tune PGroonga in some cases such as a case that you need to handle a very large database. PGroonga uses Groonga as backend. It means that you can apply tuning knowledge for Groonga to PGroonga. See the following Groonga document to tune PGroonga: