We tried by dropping indexes and it worked faster compared to what we saw earlier. We wanted to know if anybody has done any other changes that helps speed-up initial data load without dropping indexes.
PS: i have not tested this in production level loads, it was just some exp i did on my laptop.
one option would be to use pglogical extension (this was shared by Dharmendra in one the previous mails, sharing the same),
and then use pglogical_create_subscriber cli to create the initial copy via pgbasebackup and then carry on from there.
I ran the test case similar to one below in my local env, and it seems to work fine. of course i do not have TB worth of load to test, but it looks promising,
