| From: | Andres Freund <andres(at)anarazel(dot)de> |
|---|---|
| To: | Amit Khandekar <amitdkhan(dot)pg(at)gmail(dot)com> |
| Cc: | tushar <tushar(dot)ahuja(at)enterprisedb(dot)com>, Petr Jelinek <petr(dot)jelinek(at)2ndquadrant(dot)com>, Robert Haas <robertmhaas(at)gmail(dot)com>, Craig Ringer <craig(at)2ndquadrant(dot)com>, Petr Jelinek <petr(at)2ndquadrant(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Minimal logical decoding on standbys |
| Date: | 2019-06-04 15:57:54 |
| Message-ID: | 20190604155754.ns62je7viqovs2ly@alap3.anarazel.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Hi,
On 2019-05-31 17:31:34 +0530, Amit Khandekar wrote:
> On Fri, 31 May 2019 at 11:08, Amit Khandekar <amitdkhan(dot)pg(at)gmail(dot)com> wrote:
> >
> > On Thu, 30 May 2019 at 20:13, Andres Freund <andres(at)anarazel(dot)de> wrote:
> > Yes, it waits until there is a commit record, or (just tried) until a
> > checkpoint command.
That's fine with me.
> Is XLOG_RUNNING_XACTS record essential for the logical decoding to
> build a consistent snapshot ?
Yes.
> Since the restart_lsn is now ReplayRecPtr, there is no
> XLOG_RUNNING_XACTS record, and so the snapshot state is not yet
> SNAPBUILD_CONSISTENT. And so
> DecodingContextFindStartpoint()=>DecodingContextReady() never returns
> true, and hence DecodingContextFindStartpoint() goes in an infinite
> loop, until it gets XLOG_RUNNING_XACTS.
These seem like conflicting statements? Infinite loops don't terminate
until a record is logged?
Greetings,
Andres Freund
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andres Freund | 2019-06-04 15:58:53 | Re: Minimal logical decoding on standbys |
| Previous Message | Andrew Gierth | 2019-06-04 15:57:03 | Re: UCT (Re: pgsql: Update time zone data files to tzdata release 2019a.) |