[BUG] Excessive memory usage with update on STORED generated columns.

1 patchset tracked - current t139176_2

v2t139176_2posted Mar 30, 15:26successappliesrecent 0dpg 20

basee73841ffb about 24 hours ago on master

applyapplied about 13 hours ago

rebaselast tried about 13 hours ago on e73841ffb

pushabout 13 hours ago -> 093cf1ab7 branch diff vs base

Result	Att	PG	Tests	Build / test	Image	When
success	1	20	1036 / 1036	2m 11s / 4m 38s	`docker run ... :t139176`	about 13 hours ago
run 35480230985 executed 1036 - ccache 98 hit / 6524 miss - head 093cf1ab7 - digest sha256:ac450c873c8b06... - run 35480230985
success	1	20	1036 / 1036	2m 57s / 5m 49s	`docker run ... @sha256:ce6be7a...`	1 day ago
run 35411108372 executed 1036 - ccache 98 hit / 6524 miss - head 4603831dc - digest sha256:ce6be7a2085b36... - run 35411108372
success	1	20	1036 / 1036	2m 52s / 5m 24s	`docker run ... @sha256:c03c90b...`	3 days ago
run 35293221470 executed 1036 - ccache 98 hit / 6524 miss - head 83112377e - digest sha256:c03c90baa040c7... - run 35293221470
success	1	20	1036 / 1036	2m 46s / 4m 41s	`docker run ... @sha256:297ac4f...`	4 days ago
run 35168351275 executed 1036 - ccache 98 hit / 6524 miss - head 1ca60fec8 - digest sha256:297ac4fe0154fd... - run 35168351275
success	1	20	1036 / 1036	2m 55s / 5m 27s	`docker run ... @sha256:59b3b07...`	5 days ago
run 35041731204 executed 1036 - ccache 98 hit / 6524 miss - head 6d2c3eb84 - digest sha256:59b3b070918e3e... - run 35041731204
success	1	20	1036 / 1036	2m 53s / 5m 30s	`docker run ... @sha256:9ee846f...`	6 days ago
run 34914839759 executed 1036 - ccache 98 hit / 6523 miss - head ffc8fc6c0 - digest sha256:9ee846fec25914... - run 34914839759
success	1	20	1023 / 1023	2m 44s / 5m 06s	`docker run ... @sha256:33280ba...`	7 days ago
run 34793707741 executed 1023 - ccache 98 hit / 6523 miss - head d845e85e5 - digest sha256:33280baa81ac6f... - run 34793707741
success	1	20	1023 / 1023	1m 56s / 3m 53s	`docker run ... @sha256:5c802f1...`	Sep 13, 00:53
run 34728718831 executed 1023 - ccache 98 hit / 6523 miss - head 280990bdc - digest sha256:5c802f131bf072... - run 34728718831
success	1	20	1023 / 1023	1m 48s / 3m 49s	`docker run ... @sha256:a1a2ea1...`	Sep 12, 00:50
run 34662529578 executed 1023 - ccache 98 hit / 6523 miss - head 8082299d5 - digest sha256:a1a2ea16920d43... - run 34662529578
success	1	20	1022 / 1022	2m 55s / 5m 37s	`docker run ... @sha256:2e70b5a...`	Sep 11, 00:52
run 34547526366 executed 1022 - ccache 98 hit / 6523 miss - head 441c99506 - digest sha256:2e70b5a30f3758... - run 34547526366
success	1	20	1021 / 1021	2m 52s / 5m 26s	`docker run ... @sha256:a50b0cf...`	Sep 10, 00:52
run 34422279936 executed 1021 - ccache 98 hit / 6523 miss - head c41a4e94f - digest sha256:a50b0cfd71dc40... - run 34422279936
success	1	20	1020 / 1020	3m 01s / 5m 32s	`docker run ... @sha256:dc6bc67...`	Sep 09, 00:50
run 34295856137 executed 1020 - ccache 98 hit / 6523 miss - head 83b658e8e - digest sha256:dc6bc675e09d33... - run 34295856137
success	1	20	1020 / 1020	2m 46s / 5m 23s	`docker run ... @sha256:f3cef16...`	Sep 08, 00:47
run 34173840034 executed 1020 - ccache 98 hit / 6523 miss - head d18c7fa73 - digest sha256:f3cef16eeec896... - run 34173840034
success	1	20	1024 / 1024	2m 56s / 5m 28s	`docker run ... @sha256:25cb69b...`	Sep 07, 00:47
run 34069983408 executed 1024 - ccache 98 hit / 6527 miss - head bdc59e3f0 - digest sha256:25cb69bf7f5014... - run 34069983408
success	1	20	1024 / 1024	2m 56s / 4m 54s	`docker run ... @sha256:fdc78fe...`	Sep 05, 02:00
run 33937348365 executed 1024 - ccache 98 hit / 6527 miss - head dfd45922f - digest sha256:fdc78fe1ca94a7... - run 33937348365
success	1	20	1024 / 1024	2m 15s / 4m 49s	`docker run ... @sha256:ff79fc7...`	Sep 04, 02:01
run 33827218485 executed 1024 - ccache 98 hit / 6527 miss - head 64e2ac9a5 - digest sha256:ff79fc717396d0... - run 33827218485
success	1	20	1022 / 1022	2m 13s / 4m 36s	`docker run ... @sha256:b1d96bf...`	Sep 03, 01:58
run 33705157589 executed 1022 - ccache 98 hit / 6526 miss - head 828ca392b - digest sha256:b1d96bf6bdc4cd... - run 33705157589
success	1	20	1022 / 1022	2m 47s / 5m 22s	`docker run ... @sha256:a916268...`	Sep 02, 01:58
run 33580756162 executed 1022 - ccache 98 hit / 6526 miss - head 7e496cd8e - digest sha256:a9162685f0a3dc... - run 33580756162
success	1	20	1022 / 1022	2m 55s / 5m 18s	`docker run ... @sha256:7446842...`	Sep 01, 01:56
run 33459961116 executed 1022 - ccache 98 hit / 6526 miss - head b117f34e1 - digest sha256:744684290d224a... - run 33459961116
success	1	20	1021 / 1021	2m 48s / 5m 18s	`docker run ... @sha256:aed61ae...`	Aug 31, 01:56
run 33348472966 executed 1021 - ccache 98 hit / 6525 miss - head 8aea44f6b - digest sha256:aed61ae3ee1657... - run 33348472966
success	1	20	1021 / 1021	2m 46s / 5m 02s	`docker run ... @sha256:d6f3d20...`	Aug 30, 01:54
run 33286294416 executed 1021 - ccache 98 hit / 6525 miss - head 6d3800e74 - digest sha256:d6f3d20d757986... - run 33286294416
success	1	20	1021 / 1021	2m 55s / 5m 30s	`docker run ... @sha256:6ba633b...`	Aug 29, 01:54
run 33227110587 executed 1021 - ccache 98 hit / 6525 miss - head 9d3efa19a - digest sha256:6ba633b8aabb2e... - run 33227110587
success	1	20	1021 / 1021	2m 54s / 5m 16s	`docker run ... @sha256:c567072...`	Aug 28, 01:38
run 33132896951 executed 1021 - ccache 98 hit / 6525 miss - head a24388d0e - digest sha256:c5670726db77f9... - run 33132896951
success	1	20	1021 / 1021	2m 54s / 5m 34s	`docker run ... @sha256:0b1ba24...`	Aug 27, 01:37
run 33030087248 executed 1021 - ccache 98 hit / 6525 miss - head 4c9e86310 - digest sha256:0b1ba24ccc490d... - run 33030087248
success	1	20	1024 / 1024	2m 52s / 5m 20s	`docker run ... @sha256:6bbb61f...`	Aug 26, 01:23
run 32917648712 executed 1024 - ccache 98 hit / 6525 miss - head baa2ab929 - digest sha256:6bbb61fb3495ca... - run 32917648712
success	1	20	1024 / 1024	2m 46s / 5m 02s	`docker run ... @sha256:910e053...`	Aug 25, 01:10
run 32795811969 executed 1024 - ccache 98 hit / 6525 miss - head a463d9a40 - digest sha256:910e05324f156d... - run 32795811969
success	1	20	1023 / 1023	2m 51s / 5m 28s	`docker run ... @sha256:cf6da19...`	Aug 24, 01:08
run 32678277734 executed 1023 - ccache 98 hit / 6525 miss - head e07cb6e19 - digest sha256:cf6da191fdc62c... - run 32678277734
success	1	20	1023 / 1023	2m 56s / 5m 31s	`docker run ... @sha256:60b3ebe...`	Aug 23, 01:06
run 32609098763 executed 1023 - ccache 98 hit / 6525 miss - head 9c376d6ce - digest sha256:60b3ebecfc0b81... - run 32609098763
success	1	20	1023 / 1023	2m 52s / 5m 31s	`docker run ... @sha256:f0c109f...`	Aug 22, 01:06
run 32541862303 executed 1023 - ccache 98 hit / 6525 miss - head 7ef9fa448 - digest sha256:f0c109fa31aab9... - run 32541862303
success	1	20	1023 / 1023	2m 56s / 5m 32s	`docker run ... @sha256:27abbf3...`	Aug 21, 01:04
run 32434321426 executed 1023 - ccache 98 hit / 6525 miss - head 5fd62cb7c - digest sha256:27abbf3752f0c5... - run 32434321426
success	1	20	1023 / 1023	2m 46s / 5m 05s	`docker run ... @sha256:31a349a...`	Aug 20, 01:01
run 32318883452 executed 1023 - ccache 98 hit / 6525 miss - head 09b72d4fd - digest sha256:31a349a378b303... - run 32318883452
success	1	20	1023 / 1023	2m 48s / 5m 09s	`docker run ... @sha256:c96263d...`	Aug 19, 01:01
run 32202740502 executed 1023 - ccache 98 hit / 6525 miss - head 5d85edf81 - digest sha256:c96263dd71aa0b... - run 32202740502
success	1	20	1019 / 1019	2m 52s / 5m 30s	`docker run ... @sha256:55a81a2...`	Aug 18, 00:59
run 32085924751 executed 1019 - ccache 98 hit / 6524 miss - head 9f7a43ec6 - digest sha256:55a81a265a3137... - run 32085924751
success	1	20	1019 / 1019	2m 57s / 5m 21s	`docker run ... @sha256:b286689...`	Aug 17, 00:58
run 31983022307 executed 1019 - ccache 98 hit / 6524 miss - head a3519e3a3 - digest sha256:b2866897f6bdf9... - run 31983022307
success	1	20	1019 / 1019	2m 12s / 4m 46s	`docker run ... @sha256:69b3dd6...`	Aug 16, 00:45
run 31917474784 executed 1019 - ccache 98 hit / 6524 miss - head 812709c6f - digest sha256:69b3dd6ffa0c89... - run 31917474784
success	1	20	1019 / 1019	2m 56s / 5m 36s	`docker run ... @sha256:db9991a...`	Aug 15, 00:43
run 31853865909 executed 1019 - ccache 98 hit / 6524 miss - head 8d1113efe - digest sha256:db9991a241d55d... - run 31853865909
success	1	20	1019 / 1019	2m 45s / 4m 53s	`docker run ... @sha256:e57ed30...`	Aug 14, 00:41
run 31757558090 executed 1019 - ccache 165 hit / 6457 miss - head bbbae877f - digest sha256:e57ed3076c4877... - run 31757558090
success	1	20	1019 / 1019	2m 57s / 5m 38s	`docker run ... @sha256:3167634...`	Aug 13, 00:40
run 31654535085 executed 1019 - ccache 165 hit / 6457 miss - head 7829db6c6 - digest sha256:31676347cf6933... - run 31654535085
success	1	20	1019 / 1019	2m 56s / 5m 16s	`docker run ... @sha256:9af04ce...`	Aug 12, 00:40
run 31550188244 executed 1019 - ccache 165 hit / 6453 miss - head df001cb73 - digest sha256:9af04ceed085da... - run 31550188244
success	1	20	1019 / 1019	2m 12s / 4m 53s	`docker run ... @sha256:a2fdca5...`	Aug 11, 00:39
run 31445962450 executed 1019 - ccache 165 hit / 6453 miss - head 1ab0ccd4e - digest sha256:a2fdca58ef468d... - run 31445962450
success	1	20	1019 / 1019	2m 51s / 5m 36s	`docker run ... @sha256:0fa441c...`	Aug 10, 00:41
run 31344318286 executed 1019 - ccache 166 hit / 6452 miss - head c82dc1781 - digest sha256:0fa441ce9630ab... - run 31344318286
success	1	20	1019 / 1019	2m 57s / 5m 35s	`docker run ... @sha256:a5efa3b...`	Aug 07, 20:14
run 31214150379 executed 1019 - ccache 166 hit / 6452 miss - head 85545b23e - digest sha256:a5efa3b745bac4... - run 31214150379
success	1	20	1018 / 1018	2m 41s / 4m 40s	`docker run ... @sha256:391831d...`	Aug 06, 22:47
run 31127672951 executed 1018 - ccache 166 hit / 6452 miss - head 72a1e2a69 - digest sha256:391831db9518c4... - run 31127672951
success	1	20	1018 / 1018	2m 16s / 4m 44s	`docker run ... @sha256:aab4249...`	Aug 05, 16:55
run 31026564490 executed 1018 - ccache 166 hit / 6452 miss - head 42e082918 - digest sha256:aab4249426aedf... - run 31026564490
success	1	20	1018 / 1018	2m 52s / 5m 30s	`docker run ... @sha256:95b153f...`	Aug 04, 16:52
run 30930315712 executed 1018 - ccache 166 hit / 6452 miss - head 325cd3d5b - digest sha256:95b153f14cfb58... - run 30930315712
success	1	20	1017 / 1017	2m 54s / 5m 39s	`docker run ... @sha256:4faaacc...`	Aug 03, 16:51
run 30833186267 executed 1017 - ccache 166 hit / 6452 miss - head c89c029e4 - digest sha256:4faaacc6f80d76... - run 30833186267
success	1	20	1017 / 1017	2m 10s / 4m 40s	`docker run ... @sha256:e280a5c...`	Aug 02, 16:48
run 30757077575 executed 1017 - ccache 166 hit / 6452 miss - head 1142cf6c7 - digest sha256:e280a5c74fb0bf... - run 30757077575
success	1	20	1017 / 1017	2m 56s / 5m 31s	`docker run ... @sha256:76c99b5...`	Aug 01, 16:47
run 30708522192 executed 1017 - ccache 166 hit / 6452 miss - head 7122d55a4 - digest sha256:76c99b53ef7d82... - run 30708522192
success	1	20	1017 / 1017	2m 54s / 5m 24s	`docker run ... @sha256:2f0eda7...`	Jul 31, 16:47
run 30647733774 executed 1017 - ccache 166 hit / 6452 miss - head df32a65cb - digest sha256:2f0eda78c57165... - run 30647733774
success	1	20	1016 / 1016	2m 52s / 4m 51s	`docker run ... @sha256:d432414...`	Jul 30, 16:45
run 30562085208 executed 1016 - ccache 166 hit / 6452 miss - head b387dba9e - digest sha256:d432414659496b... - run 30562085208
success	1	20	1016 / 1016	2m 49s / 5m 35s	`docker run ... @sha256:66a608b...`	Jul 29, 16:46
run 30471351200 executed 1016 - ccache 166 hit / 6452 miss - head 65b3225f4 - digest sha256:66a608bc7b6f55... - run 30471351200
success	1	20	1014 / 1014	2m 54s / 5m 25s	`docker run ... @sha256:c6ac85d...`	Jul 28, 16:44
run 30378765940 executed 1014 - ccache 166 hit / 6452 miss - head 7f5038273 - digest sha256:c6ac85db79d27b... - run 30378765940
success	1	20	1013 / 1013	2m 44s / 4m 33s	`docker run ... @sha256:1baa711...`	Jul 27, 02:33
run 30232074203 executed 1013 - ccache 166 hit / 6452 miss - head 7bac4d1cc - digest sha256:1baa711dd8334b... - run 30232074203