| From: | Vijaykumar Jain <vijaykumarjain(dot)github(at)gmail(dot)com> |
|---|---|
| To: | Nikhil Shetty <nikhil(dot)dba04(at)gmail(dot)com> |
| Cc: | Hüseyin Demir <demirhuseyinn(dot)94(at)gmail(dot)com>, Pgsql Performance <pgsql-performance(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Logical Replication speed-up initial data |
| Date: | 2021-08-05 19:20:39 |
| Message-ID: | CAM+6J96YBmiDWrgthupex4XhgV9njQKQNZ8d91Sig+gZocYJ9w@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On Fri, 6 Aug 2021 at 00:15, Nikhil Shetty <nikhil(dot)dba04(at)gmail(dot)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.
pglogical/pglogical_create_subscriber.c at REL2_x_STABLE ·
2ndQuadrant/pglogical (github.com)
<https://github.com/2ndQuadrant/pglogical/blob/REL2_x_STABLE/pglogical_create_subscriber.c#L704>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jeff Janes | 2021-08-05 20:03:00 | Re: Logical Replication speed-up initial data |
| Previous Message | Nikhil Shetty | 2021-08-05 18:45:15 | Re: Logical Replication speed-up initial data |