Re: Single transaction in the tablesync worker? - Mailing list pgsql-hackers

From Ajin Cherian
Subject Re: Single transaction in the tablesync worker?
Date
Msg-id CAFPTHDaHB=-d5WKijnPfviNNHXM+F6dokk5YOnwXPsEYPWZZEw@mail.gmail.com
Whole thread Raw
In response to Re: Single transaction in the tablesync worker?  (Peter Smith <smithpb2250@gmail.com>)
List pgsql-hackers
On Wed, Dec 30, 2020 at 5:08 PM Peter Smith <smithpb2250@gmail.com> wrote:

>
> PSA my v9 WIP patch for the Solution1 which addresses some recent
> review comments, and other minor changes.

I did some tests using the test suite prepared by Erik Rijkers in [1]
during the initial design of tablesync.

Back then, they had seen some errors while doing multiple commits in
initial tablesync. So I've rerun the test script on the v9 patch
applied on HEAD and found no errors.
The script runs pgbench, creates a pub/sub on a standby server, and
all of the pgbench tables are replicated to the standby. The contents
of the tables are compared at
the end of each run to make sure they are identical.
I have run it for around 12 hours, and it worked without any errors.
Attaching the script I used.

regards,
Ajin Cherian
Fujitsu Australia

[1]- https://www.postgresql.org/message-id/93d02794068482f96d31b002e0eb248d%40xs4all.nl

Attachment

pgsql-hackers by date:

Previous
From: Peter Smith
Date:
Subject: Re: Adding new commitfest entry?
Next
From: Amit Kapila
Date:
Subject: Re: fix typo in ReorderBufferProcessTXN