| From: | Xuneng Zhou <xunengzhou(at)gmail(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Alexander Korotkov <aekorotkov(at)gmail(dot)com>, Heikki Linnakangas <hlinnaka(at)iki(dot)fi>, Peter Eisentraut <peter(at)eisentraut(dot)org>, Andres Freund <andres(at)anarazel(dot)de>, Thomas Munro <thomas(dot)munro(at)gmail(dot)com>, Álvaro Herrera <alvherre(at)kurilemu(dot)de>, Chao Li <li(dot)evan(dot)chao(at)gmail(dot)com>, pgsql-hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>, Michael Paquier <michael(at)paquier(dot)xyz>, jian he <jian(dot)universality(at)gmail(dot)com>, Tomas Vondra <tomas(at)vondra(dot)me>, Yura Sokolov <y(dot)sokolov(at)postgrespro(dot)ru> |
| Subject: | Re: Implement waiting for wal lsn replay: reloaded |
| Date: | 2026-04-07 02:28:52 |
| Message-ID: | CABPTF7W0GGEpTeRS8YiMX=77DJbe9jqoUEaWpWHcxxs1xvWkkA@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Hi Tom,
On Tue, Apr 7, 2026 at 10:08 AM Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>
> I wrote:
> > I wondered why my buildfarm animals got noticeably slower today.
> > There seem to be a couple of culprits, but one of them is that
> > 7e8aeb9e4 (Use WAIT FOR LSN) has caused the runtime of pg_rewind's
> > t/003_extrafiles.pl to go through the roof. On indri's host, that
> > TAP test took about 3 seconds immediately before that commit, and
> > about 45 seconds immediately after.
>
> I'm wrong: there's only one culprit. The other big change in runtime
> today is that src/test/recovery's t/033_replay_tsp_drops.pl went from
> about 4 seconds to about 46, and that jump also happened at 7e8aeb9e4.
> So we still have a mystery, but it's "what do those two tests have in
> common that is shared by no others?".
>
> regards, tom lane
Thanks for reporting this. I think it could be related to the read of
not-yet-updated writtenUpto position. I'll look into this and propose
a fix shortly.
--
Best,
Xuneng
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Noah Misch | 2026-04-07 02:42:33 | Re: Adding REPACK [concurrently] |
| Previous Message | Sami Imseih | 2026-04-07 02:23:57 | test_autovacuum/001_parallel_autovacuum is broken |