pgsql: Allow the logical_replication_mode to be used on the subscriber.

From: Amit Kapila <akapila(at)postgresql(dot)org>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Allow the logical_replication_mode to be used on the subscriber.
Date: 2023-02-02 02:55:18
Message-ID: E1pNPkr-0019iY-CZ@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Allow the logical_replication_mode to be used on the subscriber.

Extend the existing developer option 'logical_replication_mode' to help
test the parallel apply of large transactions on the subscriber.

When set to 'buffered', the leader sends changes to parallel apply workers
via a shared memory queue. When set to 'immediate', the leader serializes
all changes to files and notifies the parallel apply workers to read and
apply them at the end of the transaction.

This helps in adding tests to cover the serialization code path in
parallel streaming mode.

Author: Hou Zhijie
Reviewed-by: Peter Smith, Kuroda Hayato, Sawada Masahiko, Amit Kapila
Discussion: https://postgr.es/m/CAA4eK1+wyN6zpaHUkCLorEWNx75MG0xhMwcFhvjqm2KURZEAGw@mail.gmail.com

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/9f2213a7c575bae43a2d41abc8b60770066ca81c

Modified Files
--------------
doc/src/sgml/config.sgml | 35 +++++++++----
.../replication/logical/applyparallelworker.c | 16 ++++--
src/backend/utils/misc/guc_tables.c | 6 ++-
src/test/subscription/t/015_stream.pl | 28 ++++++++++
.../subscription/t/018_stream_subxact_abort.pl | 61 +++++++++++++++++++++-
src/test/subscription/t/023_twophase_stream.pl | 46 +++++++++++++++-
6 files changed, 172 insertions(+), 20 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Thomas Munro 2023-02-02 05:30:53 pgsql: Doc: Abstract AF_UNIX sockets don't work on Windows.
Previous Message Tom Lane 2023-02-02 02:04:01 Re: pgsql: Remove over-optimistic Assert.