PostgreSQL Documentation: max_logical_replication

Type:	`integer`
Default:	`4`
Min:	`0`
Max:	`262143`
Context:	`postmaster`
Restart:	`true`
Since:	`10`

Maximum number of logical replication worker processes

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.

Official docs

Search in source code

Recommendations

… unless logical replication is falling behind and the replica isn't handling other traffic

By annotated.conf

On StackOverflow

What exactly means the collation 'de-DE-u-kn-true'
De-Identifying PHI For HIPAA
Lazily (de-)serialize JSON with EF Core
Connect to a heroku database with pgadmin
Get breakdown from de-normalized SQL table

On pgsql-hackers

Re: GUC values - recommended way to declare the C variables?
Re: Perform streaming logical transactions by background workers and parallel apply
RE: Perform streaming logical transactions by background workers and parallel apply
GUC values - recommended way to declare the C variables?
Re: PGDOCS - Logical replication GUCs - added some xrefs

max_logical_replication_workers

Recommendations

On StackOverflow

On pgsql-hackers

Comments