Re: Logical Replication speed-up initial data

2021-08-05 Thread Jeff Janes
On Thu, Aug 5, 2021 at 12:57 AM Nikhil Shetty wrote: > Hi, > > Thank you for the suggestion. > > 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 in

Re: Logical Replication speed-up initial data

2021-08-05 Thread Vijaykumar Jain
On Fri, 6 Aug 2021 at 00:15, Nikhil Shetty wrote: > Hi Vijaykumar, > > Thanks for the details. > In this method you are saying the pg_basebackup will make the initial load > faster ? > We intend to bring only a few tables. Using pg_basebackup will clone an > entire instance. > yeah. In that case

Re: Logical Replication speed-up initial data

2021-08-05 Thread Nikhil Shetty
Hi Vijaykumar, Thanks for the details. In this method you are saying the pg_basebackup will make the initial load faster ? We intend to bring only a few tables. Using pg_basebackup will clone an entire instance. Thanks, Nikhil On Thu, Aug 5, 2021 at 7:57 PM Vijaykumar Jain < vijaykumarjain.git

Re: Logical Replication speed-up initial data

2021-08-05 Thread Nikhil Shetty
Hi Avinash, Thank you for the detailed explanation. Indexes were dropped on the destination to increase initial data load speed. We cannot stop the App on source and it is highly transactional. I had thought about this method but I am not sure after the pg_restore from where the logical replicati

Re: Logical Replication speed-up initial data

2021-08-05 Thread Avinash Kumar
Hi, On Thu, Aug 5, 2021 at 11:28 AM Vijaykumar Jain < vijaykumarjain.git...@gmail.com> wrote: > On Thu, 5 Aug 2021 at 10:27, Nikhil Shetty wrote: > >> Hi, >> >> Thank you for the suggestion. >> >> We tried by dropping indexes and it worked faster compared to what we saw >> earlier. We wanted to

Re: Logical Replication speed-up initial data

2021-08-05 Thread Vijaykumar Jain
On Thu, 5 Aug 2021 at 10:27, Nikhil Shetty wrote: > Hi, > > Thank you for the suggestion. > > 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 index

Re: Logical Replication speed-up initial data

2021-08-05 Thread Rick Otten
On Thu, Aug 5, 2021 at 12:57 AM Nikhil Shetty wrote: > Hi, > > Thank you for the suggestion. > > 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 in