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

pgroonga.max_bulk_insert_wal_record_size parameter

Since 3.2.5.

Summary

pgroonga.max_bulk_insert_wal_record_size parameter controls the max custom WAL record size for PGroonga's bulk insert.

This is used only when pgroonga_wal_resource_manager module is used.

This is a soft limit. So some WAL records may use more size than this size.

Syntax

In SQL:

SET pgroonga.max_bulk_insert_wal_record_size = size;

In postgresql.conf:

pgroonga.max_bulk_insert_wal_record_size = size

size is a size value. The default unit is KiB. You can change unit by specify suffix such as MB for MiB.

The default is 16MiB.

You can disable this soft limit by specifying 0.

Usage

Here is an example to specify 256 MiB:

pgroonga.max_bulk_insert_wal_record_size = 256MB

See also