Re: [BUG] Excessive memory usage with update on STORED generated columns. - Mailing list pgsql-hackers

From Anton A. Melnikov
Subject Re: [BUG] Excessive memory usage with update on STORED generated columns.
Date
Msg-id 420a2def-969d-4161-bacf-17e9b7a79562@postgrespro.ru
Whole thread Raw
In response to Re: [BUG] Excessive memory usage with update on STORED generated columns.  (Matthias van de Meent <boekewurm+postgres@gmail.com>)
List pgsql-hackers
Hi!

On 30.03.2026 18:26, Matthias van de Meent wrote:
> So, I think the attached patch is a more appropriate fix, it avoids
> calling into ExecInitGenerated at all when no column included in
> expressions was updated. It also adds an assertion that the function
> isn't called again once the field has been initialized. It also has
> the benefit of being backportable.
> 

Agreed that this "one floor higher" fix is rather ​​simpler
and much more native than my variant with caching.

Thanks a lot for reply!

Best regards,

-- 
Anton A. Melnikov
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company



pgsql-hackers by date:

Previous
From: Álvaro Herrera
Date:
Subject: Re: clang bug affecting greenfly
Next
From: Jelte Fennema-Nio
Date:
Subject: Re: Add GoAway protocol message for graceful but fast server shutdown/switchover