max_parallel_apply_workers_per_subscription

Maximum number of parallel apply workers per subscription. This parameter controls the amount of parallelism for streaming of in-progress transactions with subscription parameter streaming = parallel. The parallel apply workers are taken from the pool defined by max_logical_replication_workers. The default value is 2. This parameter can only be set in the postgresql.conf file or on the server command line.

English manual coverage begins with PostgreSQL 7.4. Source history and runtime observations have their own recorded version boundaries.

Reading PG 18·Select a recorded version

16 17 18 19 20

boot val: 2
category: Replication / Subscribers
context: sighup
doc same as: Unknown
documented: true
enumvals: Unknown
extra desc: Unknown
lang: en
max val: 1024
metadata version: 18
min val: 0
name: max_parallel_apply_workers_per_subscription
short desc: Maximum number of parallel apply workers per subscription.
source: pg-settings-source-snapshot
unit: Unknown
vartype: integer

Definition PG 18

The parallel apply workers are taken from the pool defined by max_logical_replication_workers.

The default value is 2. This parameter can only be set in the postgresql.conf file or on the server command line.

Compare versions

Complete source facts

doc html

<p>
        Maximum number of parallel apply workers per subscription. This
        parameter controls the amount of parallelism for streaming of
        in-progress transactions with subscription parameter
        <code class="literal">streaming = parallel</code>.
       </p><p>
        The parallel apply workers are taken from the pool defined by
        <code class="varname">max_logical_replication_workers</code>.
       </p><p>
        The default value is 2. This parameter can only be set in the
        <code class="filename">postgresql.conf</code> file or on the server command
        line.
       </p>

documentation revision

{"inputs":[{"file":"runtime-config-replication.html","kind":"same-version-reviewed-manual","locale":"en","sha256":"c0b8bd86131ec62d4df97ce480d004aa7e3544477d053f0c2d4047b9edad5cc0","version":"18.7"},{"file":"runtime-config-replication.html","kind":"same-version-reviewed-manual","locale":"zh-Hans","sha256":"83907b5f469e979a7b9ec875b5e7bdaa2ef6b85596ca31b45174f68cd7398b18","version":"18.7"}],"release":"18.7","runtime_remeasured":false,"source_revision":"pgdoc:b9f0e7232f60f380d642ac9b99226606c254b552"}

Source references

Original manual reference

Full definition and evidence JSON

Definition sources

center · PostgreSQL 18 · wiki-repair-20261023:d23549af9da950894a2095bb509b9b01ed448f441e6fd498bfa35d5894726cf2

Text language: en · wiki-repair-20261023:d23549af9da950894a2095bb509b9b01ed448f441e6fd498bfa35d5894726cf2