Process Parameters

max_worker_processes

Numeric type. Maximum number of background processes. Default value 8. Adjust based on CPU core count and business requirements. This parameter can only be set at instance startup.

max_worker_processes = 4

max_parallel_workers

Numeric type. Maximum number of workers supported for parallel operations. Cannot exceed max_worker_processes. This parameter can only be set at instance startup.

max_parallel_workers = 4        # can be used in parallel operations

max_parallel_workers_per_gather

Numeric type. Maximum number of parallel worker processes per Gather node. Default value 2.

max_parallel_workers_per_gather = 4

max_parallel_maintenance_workers

Numeric type. Number of parallel worker processes for maintenance operations (such as CREATE INDEX). Default value 2.

max_parallel_maintenance_workers = 4

old_snapshot_threshold

Numeric type (time). Time threshold for the oldest snapshot. Proper use of this parameter can help avoid "snapshot too old" errors when using snapshots. Default value -1, which disables this feature. This parameter can only be set at instance startup.

old_snapshot_threshold = -1        # 1min-60d; -1 disables; 0 is immediate (change requires restart)

max_spins_per_delay

Numeric type. Maximum number of spins per spinlock delay. Default value 1000, with a valid range of 10~1000. This parameter can only be set at instance startup.

max_spins_per_delay = 1000            # min 10, max 1000 (change requires restart)

spins_num_delays

Numeric type. Maximum number of spinlock delay opportunities. Default value 1000, with a valid range of 10~1000. Typically used together with max_spins_per_delay. This parameter can only be set at instance startup.

spins_num_delays = 1000            # min 10, max 1000 (change requires restart)