pgsql: Minimal fix for WAIT FOR ... MODE 'standby_flush'

From: Andres Freund <andres(at)anarazel(dot)de>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Minimal fix for WAIT FOR ... MODE 'standby_flush'
Date: 2026-04-07 13:52:02
Message-ID: E1wA6qX-003P9t-1w@gemulon.postgresql.org
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Minimal fix for WAIT FOR ... MODE 'standby_flush'

The investigation into the negative test performance impact of 7e8aeb9e483
lead to discovering that there are a few issues with WAIT FOR.

This commit is just a minimal fix to prevent hangs in standby_flush mode, due
to WAIT FOR ... 'standby_flush' seeing a 0 LSN if a newly started walreceiver
does not receive any writes, because the stanby is already caught up.

There are several other issues and this is isn't necessarily the best fix. But
this way we get the hangs out of the way.

Reported-by: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Discussion: https://postgr.es/m/zqbppucpmkeqecfy4s5kscnru4tbk6khp3ozqz6ad2zijz354k@w4bdf4z3wqoz

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/29e7dbf5e4daa8fafc2b18a1551e7b31c8847340

Modified Files
--------------
src/backend/replication/walreceiver.c | 2 --
src/backend/replication/walreceiverfuncs.c | 1 +
2 files changed, 1 insertion(+), 2 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Robert Haas 2026-04-07 14:16:40 pgsql: pg_stash_advice: Allow stashed advice to be persisted to disk.
Previous Message Álvaro Herrera 2026-04-07 13:34:14 pgsql: doc: Add an example of REPACK (CONCURRENTLY)