On Tue, Feb 6, 2024 at 8:21 PM Tom Lane <t...@sss.pgh.pa.us> wrote: > > Amit Kapila <amit.kapil...@gmail.com> writes: > > Yeah, I was worried about that. The other idea I have previously > > thought was to change Alter Subscription to Drop+Create Subscription. > > That should also help in bringing stability without losing any > > functionality. > > Hm, why would that fix it? >
Because for new subscriptions, we will start reading WAL from the latest WAL insert pointer on the publisher which will be after the point where publication is created. > More to the point, aren't these proposals just band-aids that > would stabilize the test without fixing the actual problem? Yes, but OTOH, this behavior has been since the beginning of logical replication. This particular test has just exposed it, so keeping BF failing for this particular test doesn't sound like the best way to remember it. -- With Regards, Amit Kapila.
