| Type: | integer |
| Default: | 2 |
| Min: | 0 |
| Max: | 262143 |
| Context: | sighup |
| Restart: | false |
| Since: | 10 |
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.
Recommendations
Consider raising to cores/2 when initially synchronizing logical replication for a new replica.
On StackOverflow
- Postgresql going mad
- Geoserver WFS + PostgreSQL with large table impossibly slow
- Why does "explain analyzing" this query fnish fast (showing a parallel plan), while running the actual query without "explain analyze" doesn't?
- PostgreSQL 13 sometimes works but sometimes huge execution time
- Postgresql sequential scan slow performance on 500 million rows