Re: Initial Schema Sync for Logical Replication - Mailing list pgsql-hackers

From vignesh C
Subject Re: Initial Schema Sync for Logical Replication
Date
Msg-id CALDaNm3W4CLaALMzNMTJd7Hpunmecib4AUZc63HmmoGvXKdV2Q@mail.gmail.com
Whole thread Raw
In response to RE: Initial Schema Sync for Logical Replication  ("Kumar, Sachin" <ssetiya@amazon.com>)
Responses RE: Initial Schema Sync for Logical Replication
List pgsql-hackers
On Thu, 31 Aug 2023 at 17:18, Kumar, Sachin <ssetiya@amazon.com> wrote:
>
> Hi Everyone, based on internal discussion with Masahiko
> I have implemented concurrent DDL support for initial schema sync.
>
> Concurrent Patch workflow
>
> 1. When TableSync worker creates a replicaton slot, It will
> save the slot lsn into pg_subscription_rel with
> SUBREL_SYNC_SCHEMA_DATA_SYNC state, and it will wait for
> its state to be SUBREL_STATE_DATASYNC.
>
> 2. Applier process will apply DDLs till tablesync lsn, and then
> it will change pg_subscription_rel state to SUBREL_STATE_DATASYNC.
>
> 3. TableSync will continue applying pending DML/DDls till it catch up.
>
> This patch needs DDL replication to apply concurrent DDLs, I have cherry-
> picked this DDL patch [0]

Can you rebase the patch and post the complete set of required changes
for the concurrent DDL, I will have a look at them.

Regards,
Vignesh



pgsql-hackers by date:

Previous
From: Michael Banck
Date:
Subject: [patch] pg_basebackup: mention that spread checkpoints are the default in --help
Next
From: vignesh C
Date:
Subject: Re: Initial Schema Sync for Logical Replication