max_sync_workers_per_subscription

Maximum number of synchronization workers per subscription. This parameter controls the amount of parallelism of the initial data copy during the subscription initialization or when new tables are added. Currently, there can be only one synchronization worker per table. The synchronization 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

10 11 12 13 14 15 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: 262143
metadata version: 18
min val: 0
name: max_sync_workers_per_subscription
short desc: Maximum number of table synchronization workers per subscription.
source: pg-settings-source-snapshot
unit: Unknown
vartype: integer

Definition PG 18

Currently, there can be only one synchronization worker per table.

The synchronization 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 synchronization workers per subscription. This
        parameter controls the amount of parallelism of the initial data copy
        during the subscription initialization or when new tables are added.
       </p><p>
        Currently, there can be only one synchronization worker per table.
       </p><p>
        The synchronization 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:c3c46e139f1cbda866b1c6857e70498ed00a7f09ea07198f632c7ddfb1558a5c

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