> On Aug 4, 2021, at 08:06, Nikhil Shetty <nikhil.dba04@xxxxxxxxx> 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.
