Re: Heavy Logging in Subscriber side when configured Logical Replication in 10.4

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: pavan95 <pavan(dot)postgresdba(at)gmail(dot)com>
Cc: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Heavy Logging in Subscriber side when configured Logical Replication in 10.4
Date: 2018-09-04 14:30:40
Message-ID: CAKFQuwaNA8XKPS7HVuG6=cjLL=oQfLYTCGaKJmmxpVzfGMvXGg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Tuesday, September 4, 2018, pavan95 <pavan(dot)postgresdba(at)gmail(dot)com> wrote:
>
> Now when an application user tries to insert another 50 records will the
> replication for "country" table now starts for the differential part, that
> is 50 records or it starts from the scratch??
>

Starting from scratch every time would make the feature unusable so, no, it
doesn't do that. It should only sync from scratch during initial
subscription creation.

David J.

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Jammie 2018-09-05 05:35:01 Fwd: postgresql Logical Replication Stream fails with “Database connection failed when reading from copy”
Previous Message Dave Cramer 2018-09-04 14:22:14 Re: postgresql Logical Replication Stream fails with “Database connection failed when reading from copy”