| Config parameter: | Default value: |
|---|---|
| force_parallel_mode | off |
| promote_trigger_file | |
| restrict_nonsystem_relation_kind | |
| vacuum_defer_cleanup_age | 0 |
| Config parameter: | Default value: |
|---|---|
| createrole_self_grant | |
| debug_io_direct | |
| debug_logical_replication_streaming | buffered |
| debug_parallel_query | off |
| enable_presorted_aggregate | on |
| gss_accept_delegation | off |
| icu_validation_level | warning |
| max_parallel_apply_workers_per_subscription | 2 |
| reserved_connections | 0 |
| scram_iterations | 4096 |
| send_abort_for_crash | off |
| send_abort_for_kill | off |
| vacuum_buffer_usage_limit | 256 |
⇑ Upgrade to 16 released on 2023-09-14 - docs
Add the database name to the process title of logical WAL senders (Tatsuhiro Nakamori)
Physical WAL senders do not display a database name.
Allow logical decoding on standbys (Bertrand Drouvot, Andres Freund, Amit Khandekar)
Snapshot WAL records are required for logical slot creation but cannot be created on standbys. To avoid delays, the new function pg_log_standby_snapshot() allows creation of such records.
Add server variable to control how logical decoding publishers transfer changes and how subscribers apply them (Shi Yu)
The variable is debug_logical_replication_streaming.
Allow logical replication initial table synchronization to copy rows in binary format (Melih Mutlu)
This is only possible for subscriptions marked as binary.
Allow parallel application of logical replication (Hou Zhijie, Wang Wei, Amit Kapila)
The CREATE SUBSCRIPTION STREAMING option now supports parallel to enable application of large transactions by parallel workers. The number of parallel workers is controlled by the new server variable max_parallel_apply_workers_per_subscription. Wait events LogicalParallelApplyMain, LogicalParallelApplyStateChange, and LogicalApplySendData were also added. Column leader_pid was added to system view pg_stat_subscription to track parallel activity.
Improve performance for logical replication apply without a primary key (Onder Kalaci, Amit Kapila)
Specifically, REPLICA IDENTITY FULL can now use btree indexes rather than sequentially scanning the table to find matches.
Allow logical replication subscribers to process only changes that have no origin (Vignesh C, Amit Kapila)
This can be used to avoid replication loops. This is controlled by the new CREATE SUBSCRIPTION ... ORIGIN option.
Perform logical replication SELECT and DML actions as the table owner (Robert Haas)
This improves security and now requires subscription owners to be either superusers or to have SET ROLE permission on all roles owning tables in the replication set. The previous behavior of performing all operations as the subscription owner can be enabled with the subscription run_as_owner option.