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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: pavan95 <pavan.postgresdba@xxxxxxxxx>
Subject: Re: Heavy Logging in Subscriber side when configured Logical Replication in 10.4
From: "David G. Johnston" <david.g.johnston@xxxxxxxxx>
Date: Tue, 4 Sep 2018 07:30:40 -0700
Cc: "pgsql-admin@xxxxxxxxxxxxxx" <pgsql-admin@xxxxxxxxxxxxxx>
In-reply-to: <1536056608564-0.post@n3.nabble.com>
References: <1535792170623-0.post@n3.nabble.com> <5b79452e-cec6-c93c-76de-968be43be45e@matrix.gatewaynet.com> <1535961028810-0.post@n3.nabble.com> <ba731059-dfd7-2d34-b3a5-83a20b564a1d@matrix.gatewaynet.com> <1535963171985-0.post@n3.nabble.com> <6bb2a6ba-0425-c81c-baa9-8e56b56072df@matrix.gatewaynet.com> <1536040715349-0.post@n3.nabble.com> <771014ee-d282-f6db-911f-bfedac56c838@matrix.gatewaynet.com> <1536045135431-0.post@n3.nabble.com> <c8e8b1cc-dede-0d90-2476-f16cfe543564@matrix.gatewaynet.com> <1536056608564-0.post@n3.nabble.com>

On Tuesday, September 4, 2018, pavan95 <pavan.postgresdba@xxxxxxxxx> 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.

Follow-Ups:
- Re: Heavy Logging in Subscriber side when configured Logical Replication in 10.4
  - From: pavan95

References:
- Re: Heavy Logging in Subscriber side when configured Logical Replication in 10.4
  - From: pavan95
- Re: Heavy Logging in Subscriber side when configured Logical Replication in 10.4
  - From: Achilleas Mantzios
- Re: Heavy Logging in Subscriber side when configured Logical Replication in 10.4
  - From: pavan95
- Re: Heavy Logging in Subscriber side when configured Logical Replication in 10.4
  - From: Achilleas Mantzios
- Re: Heavy Logging in Subscriber side when configured Logical Replication in 10.4
  - From: pavan95
- Re: Heavy Logging in Subscriber side when configured Logical Replication in 10.4
  - From: Achilleas Mantzios
- Re: Heavy Logging in Subscriber side when configured Logical Replication in 10.4
  - From: pavan95
- Re: Heavy Logging in Subscriber side when configured Logical Replication in 10.4
  - From: Achilleas Mantzios
- Re: Heavy Logging in Subscriber side when configured Logical Replication in 10.4
  - From: pavan95
- Re: Heavy Logging in Subscriber side when configured Logical Replication in 10.4
  - From: Achilleas Mantzios
- Re: Heavy Logging in Subscriber side when configured Logical Replication in 10.4
  - From: pavan95

Prev by Date: Re: User to get locked after three wrong login attempts.
Next by Date: Re: Heavy Logging in Subscriber side when configured Logical Replication in 10.4
Previous by thread: Re: Heavy Logging in Subscriber side when configured Logical Replication in 10.4
Next by thread: Re: Heavy Logging in Subscriber side when configured Logical Replication in 10.4
Index(es):
- Date
- Thread

[Index of Archives] [KVM ARM] [KVM ia64] [KVM ppc] [Virtualization Tools] [Spice Development] [Libvirt] [Libvirt Users] [Linux USB Devel] [Linux Audio Users] [Yosemite Questions] [Linux Kernel] [Linux SCSI] [XFree86]