> On Aug 4, 2021, at 08:06, Nikhil Shetty <nikhil(dot)dba04(at)gmail(dot)com> wrote:
>
> How can we increase the speed of the initial data load without dropping the indexes on destination?
You can do the usual steps of increasing checkpoint_timeout and max_wal_size (since incoming logical replication changes are WAL logged) and setting synchronous_commit = off, but those will be modest improvements. You will get an enormous benefit from dropping indexes and foreign key constraints, and those aren't much use during the initial sync anyway.