Re: Expanding HOT updates for expression and partial indexes

From: "Burd, Greg" <gregburd(at)amazon(dot)com>
To: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
Cc: "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Expanding HOT updates for expression and partial indexes
Date: 2025-02-10 12:02:27
Message-ID: C6C63FAF-10EA-4E58-81C3-BA4F609541CC@amazon.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Feb 9, 2025, at 1:14 AM, Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> wrote:
>
> I think that the goal of this patch is interesting and desirable.

Thanks for taking a look at it. Which version did you prefer, v3 or v4?

> The greatest concern for me is the performance impact.

Agreed, I’m still looking for ways to minimize it (suggestions welcome).

> I think that a switch is warranted, but I am not sure if it should be a GUC.
> Wouldn't it be better to have a reloption, so that this can be configured per table?

I can remove the GUC in favor of a reloption, that makes sense to me.

> Yours,
> Laurenz Albe

best,

-greg

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message torikoshia 2025-02-10 12:02:56 Re: Enhancing Memory Context Statistics Reporting
Previous Message Álvaro Herrera 2025-02-10 11:54:11 Re: Doc: Move standalone backup section, mention -X argument