Re: BUG #19628: Uninterruptible vacuum during hash index processing - Mailing list pgsql-bugs

From shihao zhong
Subject Re: BUG #19628: Uninterruptible vacuum during hash index processing
Date
Msg-id CAGRkXqTOt7NhoLS=QLMLKBL+Bzc_MMRsJhZxi+BzFT9XZNyNsw@mail.gmail.com
Whole thread
In response to Re: BUG #19628: Uninterruptible vacuum during hash index processing  (Heikki Linnakangas <hlinnaka@iki.fi>)
Responses Re: BUG #19628: Uninterruptible vacuum during hash index processing
List pgsql-bugs
Hi Heikki,

On 02/10/2026, Heikki Linnakangas wrote:
> Do we have more places where we call vacuum_delay_point() while holding
> locks?

I tried to run tests under assertion you had and I did not see any new failures.

I also asked Fable to list 28 use cases and manually check the code path
and did not find any vacuum_delay_point with LWLock holding.

But, there is a thread on hackers with the same three fixes, in case you
have not seen it. Kevin Rocker's v8 is here:

Tom suggested the Assert there, and v8-0003 adds it. 

Thanks,
Shihao

pgsql-bugs by date:

Previous
From: PG Bug reporting form
Date:
Subject: BUG #19741: `avg(double precision)` overflows on cancelling finite inputs whose mean is representable
Next
From: shihao zhong
Date:
Subject: Re: PostgreSQL 18.6/17.11: standby PANIC on restart after VM truncation