On Tuesday, October 27th, 2026 at 10:05 AM, shihao zhong <[email protected]> wrote: > Hi Greg, > > That's a signal to innovate, not remove code. > > I agree with that and I would like to spend some time to modernize hash, > I will start looking after the PG19 release and happy to review any of your > hash changes.
Sounds like a plan to me. > > Expression indexes prevent HOT updates, so maybe you could but at what > > cost? > > Haven't really tested that, just some wild thinking, but I think hash index > also > have similar limitations. This is a heap limitation, and update to a row where there is an expression index that has a column reference which was modified prevents the HOT update even if that expression didn't result in a material change to the index key. > Thanks, > Shihao -greg
