Re: [PG19] Promotion hangs behind a backend blocked on a stuck client

From: shihao zhong <zhong950419(at)gmail(dot)com>
To: Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>
Cc: Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>, Manu <manuelreyesbravo(at)gmail(dot)com>, Fujii Masao <masao(dot)fujii(at)gmail(dot)com>, pgsql-hackers(at)lists(dot)postgresql(dot)org, "Hayato Kuroda (Fujitsu)" <kuroda(dot)hayato(at)fujitsu(dot)com>, Andres Freund <andres(at)anarazel(dot)de>, Thomas Munro <thomas(dot)munro(at)gmail(dot)com>, Noah Misch <noah(at)leadboat(dot)com>
Subject: Re: [PG19] Promotion hangs behind a backend blocked on a stuck client
Date: 2026-10-21 00:39:11
Message-ID: CAGRkXqQdWsX4FUAUzn+Q_Ooj32bKji0U7X6DUeNi2qYKaQa00g@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi Masahiko,

I agree. 19 gets a note in the docs, and v6 goes to master first.

The docs patch for 19 is attached. It says what blocks, how to see the
PID, and how to get out. I am happy to change the wording.

For (2), I think it is still worth doing on master even with v6. It
would also cover replay of the enable record and recovery conflicts
with a backend stuck on a client write. Manu, do you want to post it?
If not, I am happy to take it.

Thanks,
Shihao

Attachment Content-Type Size
nocfbot-v1-19-0001-doc-Note-that-promotion-can-wait-for-a-backend-st.patch application/octet-stream 2.2 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message shihao zhong 2026-10-21 00:48:09 Re: [PATCH] Fix grouping-set nulling of variable-free grouping expressions
Previous Message shihao zhong 2026-10-21 00:35:16 Re: [PATCH] pageinspect: validate line pointers before using them