| Type: | integer |
| Default: | 4 |
| Min: | 0 |
| Max: | 262143 |
| Context: | postmaster |
| Restart: | true |
| Since: | 10 |
Specifies maximum number of logical replication workers. This includes both apply workers and table synchronization workers.
Logical replication workers are taken from the pool defined by max_worker_processes.
The default value is 4. This parameter can only be set at server start.
Recommendations
… unless logical replication is falling behind and the replica isn't handling other traffic
On StackOverflow
On pgsql-hackers
- PGDOCS - Integer configuration parameters should say "(integer)"
- Re: Invalid memory access in pg_stat_get_subscription
- Invalid memory access in pg_stat_get_subscription
- Re: Design of pg_stat_subscription_workers vs pgstats
- Re: Perform streaming logical transactions by background workers and parallel apply