Re: Recent 027_streaming_regress.pl hangs - Mailing list pgsql-hackers

From Thomas Munro
Subject Re: Recent 027_streaming_regress.pl hangs
Date
Msg-id CA+hUKGLHUrFnzi4NOcH_WNaVPnjPqPgENY8QjUMSvOPd94QWCQ@mail.gmail.com
Whole thread Raw
In response to Re: Recent 027_streaming_regress.pl hangs  (Michael Paquier <michael@paquier.xyz>)
Responses Re: Recent 027_streaming_regress.pl hangs
List pgsql-hackers
On Thu, Mar 14, 2024 at 3:27 PM Michael Paquier <michael@paquier.xyz> wrote:
> Hmm.  Perhaps 8af25652489?  That looks like the closest thing in the
> list that could have played with the way WAL is generated, hence
> potentially impacting the records that are replayed.

Yeah, I was wondering if its checkpoint delaying logic might have
got the checkpointer jammed or something like that, but I don't
currently see how.  Yeah, the replay of bulk newpages could be
relevant, but it's not exactly new technology.  One thing I wondered
about is whether the Perl "wait for catchup" thing, which generates
large volumes of useless log, could be somehow changed to actually
show the progress after some time.  Something like "I'm still waiting
for this replica to reach LSN X, but it has so far only reported LSN
Y, and here's a dump of the WAL around there"?

> 93db6cbda03, efa70c15c74 and 818fefd8fd4 came to mind, but they touch
> unrelated territory.

Hmm.



pgsql-hackers by date:

Previous
From: Masahiko Sawada
Date:
Subject: Re: Improve eviction algorithm in ReorderBuffer
Next
From: Kyotaro Horiguchi
Date:
Subject: Inconsistent printf placeholders