Isn't XLogRecord carries full information to be decoded in itself?If so a VACCUM should not be a problem in decoding?
Thanks
Sanyam Jain
From: Michael Paquier <michael.paquier@gmail.com> Sent: Monday, June 12, 2017 6:52:06 AM To: sanyam jain Cc: Pg Hackers Subject: Re: [HACKERS] Why forcing Hot_standby_feedback to be enabled when creating a logical decoding slot on standby
On Mon, Jun 12, 2017 at 3:16 PM, sanyam jain <sanyamjain22@live.in> wrote: > I have created a logical decoding slot on a standby but i haven't enabled > Hot_standby_feedback.What are the test cases where this setup will fail?
hot_standby_feedback needs to be enabled at all times in logical decoding so as the node does not remove rows that are still needed for the decoding, and a VACUUM passing by with a minimal xmin too high would cause inconsistent decoded data. -- Michael