Re: Expanding HOT updates for expression and partial indexes - Mailing list pgsql-hackers

From Burd, Greg
Subject Re: Expanding HOT updates for expression and partial indexes
Date
Msg-id 719ABDB8-E3F5-4507-AC8B-84B763C51326@amazon.com
Whole thread Raw
In response to Re: Expanding HOT updates for expression and partial indexes  (Matthias van de Meent <boekewurm+postgres@gmail.com>)
Responses Re: Expanding HOT updates for expression and partial indexes
List pgsql-hackers
Apologies for not being clear, this preserves the current behavior for summarizing indexes allowing for HOT updates
whilealso updating the index.  No degradation here that I’m aware of, indeed the tests that ensure that behavior are
unchangedand pass.
 

-greg

> On Feb 10, 2025, at 12:17 PM, Matthias van de Meent <boekewurm+postgres@gmail.com> wrote:
> 
> So, effectively this disables the amsummarizing-based optimizations of
> https://postgr.es/c/19d8e2308 ? That sounds like a bad degradation in
> behaviour.



pgsql-hackers by date:

Previous
From: Tomas Vondra
Date:
Subject: Re: BitmapHeapScan streaming read user and prelim refactoring
Next
From: Álvaro Herrera
Date:
Subject: Re: NOT ENFORCED constraint feature