| 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.
Recommendations
… unless logical replication is falling behind and the replica isn't handling other traffic
On StackOverflow
On pgsql-hackers
- Re: "ERROR: deadlock detected" when replicating TRUNCATE
- Re: fdatasync performance problem with large number of DB files
- Re: doc review for v14
- RE: "ERROR: deadlock detected" when replicating TRUNCATE
- Re: Logical Replication - behavior of ALTER PUBLICATION .. DROP TABLE and ALTER SUBSCRIPTION .. REFRESH PUBLICATION