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
- PostgreSQL 13 sometimes works but sometimes huge execution time
- 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?