On Thu, 31 Aug 2023 at 17:18, Kumar, Sachin <sset...@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