| 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
- Postgresql 10 logical replication not working
- 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: Invalid data directory | Can't open PID file /var/run/postgresql/10-main.pid (yet?) after start: No such file or directory