Optimizing performance v7

Once you're familiar with setting up and managing your replication system, you mmight look for ways to optimize the performance of replications. Various publication server and subscription server configuration options are available for improving the performance of snapshot and synchronization replications.

Set the publication server and subscription server configuration options in the publication server and subscription server configuration files. See Publication and subscription server configuration options for a detailed explanation of how to set the configuration options in these files.

Note

Most of these configuration options also apply to multi-master replication systems. Options that apply to multi-master replication systems are those that apply to the publication server. They aren't specific to a database product other than Postgres (such as an Oracle feature).

optimizing_snapshot_replication optimize_sync_replication