Re: Optimize update of tables with generated columns

2020-02-17 Thread Peter Eisentraut
On 2020-02-13 16:16, Pavel Stehule wrote: čt 13. 2. 2020 v 14:40 odesílatel Peter Eisentraut > napsal: On 2019-12-21 07:47, Peter Eisentraut wrote: > When updating a table row with generated columns, we only need to > recompute those genera

Re: Optimize update of tables with generated columns

2020-02-13 Thread Pavel Stehule
čt 13. 2. 2020 v 14:40 odesílatel Peter Eisentraut < peter.eisentr...@2ndquadrant.com> napsal: > On 2019-12-21 07:47, Peter Eisentraut wrote: > > When updating a table row with generated columns, we only need to > > recompute those generated columns whose base columns have changed in > > this upda

Re: Optimize update of tables with generated columns

2020-02-13 Thread Peter Eisentraut
/* ANALYZE_H */ -- 2.25.0 From 017d31b53af07a5599028099e38f7422401888c2 Mon Sep 17 00:00:00 2001 From: Peter Eisentraut Date: Fri, 20 Dec 2019 22:52:31 +0100 Subject: [PATCH v2 2/2] Optimize update of tables with generated columns When updating a table row with generated

Optimize update of tables with generated columns

2019-12-20 Thread Peter Eisentraut
velopment, 24x7 Support, Remote DBA, Training & Services From 3b80f3147c0e983a2e8ad41be7df54c6480c0d8f Mon Sep 17 00:00:00 2001 From: Peter Eisentraut Date: Fri, 20 Dec 2019 22:52:31 +0100 Subject: [PATCH] Optimize update of tables with generated columns When updating a table row with gene