Postgres Pro
Downloads
Home   >   mailing lists

Re: Logical Replication speed-up initial data - Mailing list pgsql-performance

From Vijaykumar Jain
Subject Re: Logical Replication speed-up initial data
Date
Msg-id CAM+6J96YBmiDWrgthupex4XhgV9njQKQNZ8d91Sig+gZocYJ9w@mail.gmail.com
Whole thread Raw
In response to Re: Logical Replication speed-up initial data  (Nikhil Shetty <nikhil.dba04@gmail.com>)
List pgsql-performance
Tree view
On Fri, 6 Aug 2021 at 00:15, Nikhil Shetty <nikhil.dba04@gmail.com> 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, this will not be useful. I assumed you wanted all tables.



pgsql-performance by date:

Previous
From: Nikhil Shetty
Date:
Subject: Re: Logical Replication speed-up initial data
Next
From: Jeff Janes
Date:
Subject: Re: Logical Replication speed-up initial data