Configuration

All the GUC parameters require the postmaster restart.

orioledb.main_buffers

Default	64 MB

The size of shared memory, where hot data pages of OrioleDB tables are cached. This parameter is analog of the built-in shared_buffers GUC parameter.

orioledb.free_tree_buffers

Default	8 MB

Shared memory size for metadata of block allocators for compressed tables. We recommend increasing the value of this parameter to work with large compressed tables.

orioledb.catalog_buffers

Default	8 MB

Shared memory size of table metadata. We recommend increasing the value of this parameter to work with a large number of tables.

orioledb.undo_buffers

Default	1 MB

The shared memory ring buffer size for older versions of rows and pages.

orioledb.recovery_pool_size

Default	3

The number of recovery workers row-level WAL based recovery. We recommend increasing the value of this parameter for systems with a large number of CPU cores.

orioledb.recovery_queue_size

Default	8 MB

The size of shared memory for message queues related to recovery workers.

orioledb.checkpoint_completion_ratio

Default	0.5

The fraction of OrioleDB tables checkpoint time within the whole checkpoint time. We recommend setting this value to 1.0 if only OrioleDB tables are used.

orioledb.bgwriter_num_workers

Default	1

The number of background writer processes, which flushes dirty pages of OrioleDB tables in the background. We recommend setting values greater than 1 for systems with a large number of CPU cores.

orioledb.max_io_concurrency

Default	0 (off)

Maximum number of concurrent IO operations issued by OrioleDB in parallel. We recommend setting this parameter when the OS kernel becomes a bottleneck for high concurrent IO.

orioledb.device_filename

Default	Not set

Path to the block device for block device mode.

orioledb.device_length

Default	1 GB

The length of the block device.

orioledb.use_mmap

Default	off

Specify whether to use mmap to work with the block device. We recommend setting on value for NVRAM.