| 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(-)
| 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) |