| Type: | integer |
| Default: | 4 |
| Min: | 0 |
| Max: | 262143 |
| Context: | postmaster |
| Restart: | true |
| Since: | 10 |
Specifies maximum number of logical replication workers. This includes leader apply workers, parallel 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
- Re: Adding a '--clean-publisher-objects' option to 'pg_createsubscriber' utility.
- POC: enable logical decoding when wal_level = 'replica' without a server restart
- Re: Logical Replication of sequences
- Re: POC: enable logical decoding when wal_level = 'replica' without a server restart
- RE: Adding a '--clean-publisher-objects' option to 'pg_createsubscriber' utility.