This is a document for PGroonga 2.X and 3.X. See PGroonga 1.x document when you're using old PGroonga.

pgroonga.enable_wal_resource_manager parameter

Since 3.2.1.

Available in PostgreSQL 15 or higher.

Summary

pgroonga.enable_wal_resource_manager parameter controls whether WAL Resource Manager is enabled or not.

If you enable WAL Resource Manager support, WAL for PGroonga WAL Resource Manager is generated when updating PGroonga index. See Streaming replication by WAL resource manager for details.

If you enable WAL Resource Manager support, update performance will be decreased because some extra disk writes are needed.

The default value is off. It means that PGroonga doesn't generate WAL.

It is used with pgroonga_wal_resource_manager module.

Syntax

In SQL:

SET pgroonga.enable_wal_resource_manager = boolean;

In postgresql.conf:

pgroonga.enable_wal_resource_manager = boolean

boolean is a boolean value. There are some literals for boolean value such as on, off, true, false, yes and no.

Usage

Here is an example SQL to enable WAL Resource Manager support:

SET pgroonga.enable_wal_resource_manager = on;

Here is an example configration to enable WAL Resource Manager support:

pgroonga.enable_wal_resource_manager = on

See also