Subquery pull-up increases jointree search space

2 patchsets tracked - current t53275_16

v16t53275_16posted Jun 09, 10:43tests failedappliesrecent 0dpg 20

base9e17d25e7 about 12 hours ago on master

applyapplied about 10 hours ago

rebaselast tried about 10 hours ago on 9e17d25e7

pushabout 10 hours ago -> ec504f286 branch diff vs base

Result	Att	PG	Tests	Build / test	Image	When
tests failed	1	20	986 / 988	2m 00s / 4m 26s	`docker run ... :t53275`	about 10 hours ago
run 35497140374 failed: postgres_fdw/postgres_fdw, postgres_fdw/query_cancel executed 988 - ccache 98 hit / 6524 miss - head ec504f286 - digest sha256:6b2a044a4e3b8e... - run 35497140374
tests failed	1	20	986 / 988	2m 18s / 4m 09s	`docker run ... @sha256:99b0b8d...`	1 day ago
run 35429504543 failed: postgres_fdw/postgres_fdw, postgres_fdw/query_cancel executed 988 - ccache 98 hit / 6524 miss - head 4c1a32825 - digest sha256:99b0b8db795c5b... - run 35429504543
tests failed	1	20	986 / 988	1m 57s / 4m 23s	`docker run ... @sha256:f53242a...`	2 days ago
run 35319602889 failed: postgres_fdw/postgres_fdw, postgres_fdw/query_cancel executed 988 - ccache 98 hit / 6524 miss - head 882536788 - digest sha256:f53242a3992dde... - run 35319602889
tests failed	1	20	989 / 991	2m 53s / 5m 40s	`docker run ... @sha256:8b5db9d...`	3 days ago
run 35194446959 failed: postgres_fdw/postgres_fdw, postgres_fdw/query_cancel executed 991 - ccache 98 hit / 6524 miss - head 2c39c5b1f - digest sha256:8b5db9da5b1cb5... - run 35194446959
tests failed	1	20	989 / 991	2m 10s / 4m 39s	`docker run ... @sha256:70872f1...`	4 days ago
run 35068306885 failed: postgres_fdw/postgres_fdw, postgres_fdw/query_cancel executed 991 - ccache 98 hit / 6524 miss - head 6a99fdff2 - digest sha256:70872f125bb87f... - run 35068306885
tests failed	1	20	986 / 988	2m 14s / 4m 16s	`docker run ... @sha256:344d083...`	5 days ago
run 34941257518 failed: postgres_fdw/postgres_fdw, postgres_fdw/query_cancel executed 988 - ccache 98 hit / 6523 miss - head 7d21262c4 - digest sha256:344d0831efc92d... - run 34941257518
tests failed	1	20	973 / 975	2m 54s / 5m 29s	`docker run ... @sha256:2490e67...`	6 days ago
run 34817200920 failed: postgres_fdw/postgres_fdw, postgres_fdw/query_cancel executed 975 - ccache 98 hit / 6523 miss - head f81e517d2 - digest sha256:2490e6758a9859... - run 34817200920
tests failed	1	20	977 / 979	2m 13s / 4m 11s	`docker run ... @sha256:6074119...`	Sep 13, 06:57
run 34743565301 failed: postgres_fdw/postgres_fdw, postgres_fdw/query_cancel executed 979 - ccache 98 hit / 6523 miss - head 9e1332930 - digest sha256:60741196ae2292... - run 34743565301
tests failed	1	20	973 / 975	2m 55s / 5m 23s	`docker run ... @sha256:65ca8c3...`	Sep 12, 06:51
run 34678764237 failed: postgres_fdw/postgres_fdw, postgres_fdw/query_cancel executed 975 - ccache 98 hit / 6523 miss - head 86e18c9d5 - digest sha256:65ca8c3b612666... - run 34678764237
tests failed	1	20	975 / 977	1m 51s / 4m 03s	`docker run ... @sha256:c2927e4...`	Sep 11, 06:48
run 34570902940 failed: postgres_fdw/postgres_fdw, postgres_fdw/query_cancel executed 977 - ccache 98 hit / 6523 miss - head aaf1d2fc8 - digest sha256:c2927e4afe4caa... - run 34570902940
tests failed	1	20	972 / 974	2m 57s / 5m 26s	`docker run ... @sha256:b44e805...`	Sep 10, 06:48
run 34446080290 failed: postgres_fdw/postgres_fdw, postgres_fdw/query_cancel executed 974 - ccache 98 hit / 6523 miss - head 51f198cf5 - digest sha256:b44e80591bd3cd... - run 34446080290
tests failed	1	20	970 / 972	2m 27s / 4m 34s	`docker run ... @sha256:4d42479...`	Sep 09, 06:46
run 34319833297 failed: postgres_fdw/postgres_fdw, postgres_fdw/query_cancel executed 972 - ccache 98 hit / 6523 miss - head b60584c2f - digest sha256:4d42479a7ed570... - run 34319833297
tests failed	1	20	970 / 972	2m 55s / 5m 32s	`docker run ... @sha256:8be318c...`	Sep 08, 06:44
run 34195196524 failed: postgres_fdw/postgres_fdw, postgres_fdw/query_cancel executed 972 - ccache 98 hit / 6523 miss - head f24b20b79 - digest sha256:8be318c3cd1d3e... - run 34195196524
tests failed	1	20	974 / 976	2m 48s / 4m 39s	`docker run ... @sha256:f17bfce...`	Sep 07, 06:43
run 34091256529 failed: postgres_fdw/postgres_fdw, postgres_fdw/query_cancel executed 976 - ccache 98 hit / 6527 miss - head e4a4cde8c - digest sha256:f17bfce0519332... - run 34091256529
tests failed	1	20	974 / 976	2m 09s / 4m 25s	`docker run ... @sha256:2e38e0b...`	Sep 05, 08:35
run 33955245980 failed: postgres_fdw/postgres_fdw, postgres_fdw/query_cancel executed 976 - ccache 98 hit / 6527 miss - head a24b6ec1b - digest sha256:2e38e0b92bb1da... - run 33955245980
tests failed	1	20	974 / 976	2m 56s / 5m 36s	`docker run ... @sha256:659130a...`	Sep 04, 08:35
run 33853295502 failed: postgres_fdw/postgres_fdw, postgres_fdw/query_cancel executed 976 - ccache 98 hit / 6527 miss - head 59c40be50 - digest sha256:659130a94fe0ed... - run 33853295502
tests failed	1	20	973 / 975	2m 10s / 4m 40s	`docker run ... @sha256:58ab4df...`	Sep 03, 08:32
run 33733063208 failed: postgres_fdw/postgres_fdw, postgres_fdw/query_cancel executed 975 - ccache 98 hit / 6526 miss - head 03a5c1391 - digest sha256:58ab4dfb0a44ac... - run 33733063208
tests failed	1	20	972 / 974	2m 54s / 5m 20s	`docker run ... @sha256:6c9a554...`	Sep 02, 08:34
run 33608283760 failed: postgres_fdw/postgres_fdw, postgres_fdw/query_cancel executed 974 - ccache 98 hit / 6526 miss - head b5ef5bc5f - digest sha256:6c9a55481d5720... - run 33608283760
tests failed	1	20	971 / 973	2m 56s / 5m 10s	`docker run ... @sha256:cf7cce4...`	Sep 01, 08:32
run 33486379418 failed: postgres_fdw/postgres_fdw, postgres_fdw/query_cancel executed 973 - ccache 98 hit / 6519 miss - head 7c5a55f5c - digest sha256:cf7cce4b1617ac... - run 33486379418
tests failed	1	20	972 / 974	2m 51s / 5m 25s	`docker run ... @sha256:27d9a37...`	Aug 31, 08:12
run 33370612111 failed: postgres_fdw/postgres_fdw, postgres_fdw/query_cancel executed 974 - ccache 98 hit / 6526 miss - head 88927d711 - digest sha256:27d9a378081d51... - run 33370612111
tests failed	1	20	971 / 973	2m 52s / 5m 29s	`docker run ... @sha256:80c83a0...`	Aug 30, 08:06
run 33300294288 failed: postgres_fdw/postgres_fdw, postgres_fdw/query_cancel executed 973 - ccache 98 hit / 6525 miss - head 6dfb72822 - digest sha256:80c83a05113975... - run 33300294288
tests failed	1	20	971 / 973	2m 59s / 5m 41s	`docker run ... @sha256:1b85b24...`	Aug 29, 08:08
run 33241873130 failed: postgres_fdw/postgres_fdw, postgres_fdw/query_cancel executed 973 - ccache 98 hit / 6525 miss - head 3464d151a - digest sha256:1b85b2407bb0c8... - run 33241873130
tests failed	1	20	970 / 972	2m 25s / 4m 25s	`docker run ... @sha256:4ab8b26...`	Aug 28, 07:57
run 33152814760 failed: postgres_fdw/postgres_fdw, postgres_fdw/query_cancel executed 972 - ccache 98 hit / 6518 miss - head b59bfbdd0 - digest sha256:4ab8b269a84d58... - run 33152814760
tests failed	1	20	971 / 973	2m 54s / 5m 33s	`docker run ... @sha256:6d50f1c...`	Aug 27, 07:57
run 33051134989 failed: postgres_fdw/postgres_fdw, postgres_fdw/query_cancel executed 973 - ccache 98 hit / 6525 miss - head 7d00d23be - digest sha256:6d50f1ca891eca... - run 33051134989
tests failed	1	20	973 / 975	2m 54s / 5m 04s	`docker run ... @sha256:fd0392a...`	Aug 26, 07:34
run 32942583243 failed: postgres_fdw/postgres_fdw, postgres_fdw/query_cancel executed 975 - ccache 98 hit / 6518 miss - head dc7bd1fa1 - digest sha256:fd0392a3635df5... - run 32942583243
tests failed	1	20	974 / 976	2m 48s / 5m 00s	`docker run ... @sha256:ce63195...`	Aug 25, 07:34
run 32821381464 failed: postgres_fdw/postgres_fdw, postgres_fdw/query_cancel executed 976 - ccache 98 hit / 6525 miss - head bc7b1b727 - digest sha256:ce631954597e4a... - run 32821381464
tests failed	1	20	973 / 975	2m 13s / 4m 38s	`docker run ... @sha256:1aae24d...`	Aug 24, 07:32
run 32701166092 failed: postgres_fdw/postgres_fdw, postgres_fdw/query_cancel executed 975 - ccache 98 hit / 6525 miss - head e37bfdb93 - digest sha256:1aae24d160cc7b... - run 32701166092
tests failed	1	20	973 / 975	1m 55s / 4m 03s	`docker run ... @sha256:a45f9d3...`	Aug 23, 07:29
run 32625287933 failed: postgres_fdw/postgres_fdw, postgres_fdw/query_cancel executed 975 - ccache 98 hit / 6525 miss - head 7501dcacf - digest sha256:a45f9d3ddd5a37... - run 32625287933
tests failed	1	20	973 / 975	2m 48s / 4m 42s	`docker run ... @sha256:39f4915...`	Aug 22, 07:29
run 32559271866 failed: postgres_fdw/postgres_fdw, postgres_fdw/query_cancel executed 975 - ccache 98 hit / 6525 miss - head d779ccec0 - digest sha256:39f4915a86cd38... - run 32559271866
tests failed	1	20	973 / 975	2m 54s / 5m 27s	`docker run ... @sha256:cc3a50b...`	Aug 21, 07:28
run 32457991280 failed: postgres_fdw/postgres_fdw, postgres_fdw/query_cancel executed 975 - ccache 98 hit / 6525 miss - head ddd176f2c - digest sha256:cc3a50be70c70f... - run 32457991280
tests failed	1	20	976 / 978	2m 59s / 5m 39s	`docker run ... @sha256:aa5fa62...`	Aug 20, 07:27
run 32343222148 failed: postgres_fdw/postgres_fdw, postgres_fdw/query_cancel executed 978 - ccache 98 hit / 6525 miss - head ef25a5566 - digest sha256:aa5fa62523eeb7... - run 32343222148
tests failed	1	20	973 / 975	3m 00s / 5m 29s	`docker run ... @sha256:6011b00...`	Aug 19, 07:26
run 32226972608 failed: postgres_fdw/postgres_fdw, postgres_fdw/query_cancel executed 975 - ccache 98 hit / 6525 miss - head 83cab8751 - digest sha256:6011b002733140... - run 32226972608
tests failed	1	20	970 / 972	2m 53s / 5m 00s	`docker run ... @sha256:b9f9696...`	Aug 18, 07:24
run 32110419209 failed: postgres_fdw/postgres_fdw, postgres_fdw/query_cancel executed 972 - ccache 98 hit / 6524 miss - head 19bc195d1 - digest sha256:b9f96961eb4e89... - run 32110419209
tests failed	1	20	969 / 971	3m 01s / 5m 42s	`docker run ... @sha256:48dba7d...`	Aug 17, 07:23
run 32004769410 failed: postgres_fdw/postgres_fdw, postgres_fdw/query_cancel executed 971 - ccache 98 hit / 6524 miss - head 7fa35b970 - digest sha256:48dba7d902299c... - run 32004769410
tests failed	1	20	972 / 974	2m 53s / 5m 28s	`docker run ... @sha256:5987515...`	Aug 16, 07:22
run 31933245951 failed: postgres_fdw/postgres_fdw, postgres_fdw/query_cancel executed 974 - ccache 98 hit / 6524 miss - head f7468cfae - digest sha256:5987515744e89d... - run 31933245951
tests failed	1	20	969 / 971	2m 54s / 5m 23s	`docker run ... @sha256:e3c2b37...`	Aug 15, 07:21
run 31871266708 failed: postgres_fdw/postgres_fdw, postgres_fdw/query_cancel executed 971 - ccache 98 hit / 6524 miss - head bc9ccbab3 - digest sha256:e3c2b378f5c561... - run 31871266708
tests failed	1	20	969 / 971	2m 55s / 5m 26s	`docker run ... @sha256:40dc4e1...`	Aug 14, 07:19
run 31778789445 failed: postgres_fdw/postgres_fdw, postgres_fdw/query_cancel executed 971 - ccache 165 hit / 6457 miss - head 44c9f3817 - digest sha256:40dc4e150cd0c7... - run 31778789445
tests failed	1	20	969 / 971	2m 10s / 4m 32s	`docker run ... @sha256:5912fb0...`	Aug 13, 07:17
run 31676476009 failed: postgres_fdw/postgres_fdw, postgres_fdw/query_cancel executed 971 - ccache 165 hit / 6457 miss - head dd6ceabac - digest sha256:5912fb049275e4... - run 31676476009
tests failed	1	20	972 / 974	2m 47s / 5m 21s	`docker run ... @sha256:96d1865...`	Aug 12, 07:16
run 31572568476 failed: postgres_fdw/postgres_fdw, postgres_fdw/query_cancel executed 974 - ccache 165 hit / 6454 miss - head 2e37cec6d - digest sha256:96d1865cde749a... - run 31572568476
tests failed	1	20	969 / 971	2m 22s / 4m 26s	`docker run ... @sha256:02f72fc...`	Aug 11, 07:14
run 31467388239 failed: postgres_fdw/postgres_fdw, postgres_fdw/query_cancel executed 971 - ccache 165 hit / 6453 miss - head c02d3fde8 - digest sha256:02f72fcf3e5263... - run 31467388239
tests failed	1	20	969 / 971	2m 54s / 5m 21s	`docker run ... @sha256:ccf42a4...`	Aug 10, 07:10
run 31363610405 failed: postgres_fdw/postgres_fdw, postgres_fdw/query_cancel executed 971 - ccache 166 hit / 6452 miss - head 7d45c74af - digest sha256:ccf42a44779999... - run 31363610405
tests failed	1	20	969 / 971	2m 53s / 5m 05s	`docker run ... @sha256:184a4b1...`	Aug 08, 05:41
run 31241860256 failed: postgres_fdw/postgres_fdw, postgres_fdw/query_cancel executed 971 - ccache 166 hit / 6452 miss - head 2dc7a926f - digest sha256:184a4b10259ebe... - run 31241860256
tests failed	1	20	967 / 970	2m 47s / 5m 24s	`docker run ... @sha256:3ed2a23...`	Aug 07, 05:40
run 31150744891 failed: postgres_fdw/postgres_fdw, postgres_fdw/query_cancel, pgbench/001_pgbench_with_server executed 970 - ccache 166 hit / 6452 miss - head 0625ee9a7 - digest sha256:3ed2a23dccdff1... - run 31150744891
tests failed	1	20	968 / 970	2m 50s / 5m 26s	`docker run ... @sha256:93a03d2...`	Aug 06, 00:52
run 31060524154 failed: postgres_fdw/postgres_fdw, postgres_fdw/query_cancel executed 970 - ccache 166 hit / 6452 miss - head b5dfd94cc - digest sha256:93a03d25605700... - run 31060524154
tests failed	1	20	968 / 970	2m 10s / 4m 37s	`docker run ... @sha256:4b821f3...`	Aug 05, 00:50
run 30964058654 failed: postgres_fdw/postgres_fdw, postgres_fdw/query_cancel executed 970 - ccache 166 hit / 6452 miss - head ab089334d - digest sha256:4b821f310f8997... - run 30964058654
tests failed	1	20	968 / 970	2m 48s / 4m 55s	`docker run ... @sha256:1f28792...`	Aug 04, 00:50
run 30866284930 failed: postgres_fdw/postgres_fdw, postgres_fdw/query_cancel executed 970 - ccache 166 hit / 6452 miss - head f67ec1d4f - digest sha256:1f287925550c10... - run 30866284930
tests failed	1	20	967 / 969	2m 55s / 5m 10s	`docker run ... @sha256:e4c2328...`	Aug 03, 00:49
run 30774961421 failed: postgres_fdw/postgres_fdw, postgres_fdw/query_cancel executed 969 - ccache 166 hit / 6452 miss - head 159855e01 - digest sha256:e4c232809a3739... - run 30774961421
tests failed	1	20	966 / 968	2m 16s / 4m 27s	`docker run ... @sha256:83bdbb7...`	Aug 02, 00:46
run 30725530182 failed: postgres_fdw/postgres_fdw, postgres_fdw/query_cancel executed 968 - ccache 166 hit / 6445 miss - head 0c0a8d999 - digest sha256:83bdbb715800f8... - run 30725530182
tests failed	1	20	967 / 969	2m 54s / 5m 24s	`docker run ... @sha256:52fd8d8...`	Aug 01, 00:47
run 30675931874 failed: postgres_fdw/postgres_fdw, postgres_fdw/query_cancel executed 969 - ccache 166 hit / 6452 miss - head 3c81ea300 - digest sha256:52fd8d852ebab4... - run 30675931874
tests failed	1	20	965 / 967	2m 59s / 5m 32s	`docker run ... @sha256:026a8aa...`	Jul 31, 00:46
run 30593960779 failed: postgres_fdw/postgres_fdw, postgres_fdw/query_cancel executed 967 - ccache 166 hit / 6445 miss - head 83aac75bb - digest sha256:026a8aabca82fc... - run 30593960779
tests failed	1	20	966 / 968	2m 55s / 5m 29s	`docker run ... @sha256:080b285...`	Jul 30, 00:44
run 30503053299 failed: postgres_fdw/postgres_fdw, postgres_fdw/query_cancel executed 968 - ccache 166 hit / 6452 miss - head 3c96bb67b - digest sha256:080b285e951628... - run 30503053299
tests failed	1	20	965 / 967	2m 53s / 5m 21s	`docker run ... @sha256:094dec9...`	Jul 29, 00:45
run 30411477054 failed: postgres_fdw/postgres_fdw, postgres_fdw/query_cancel executed 967 - ccache 166 hit / 6452 miss - head 3dae90749 - digest sha256:094dec9a0292cc... - run 30411477054

v6t53275_6posted May 13, 15:11tests failedsupersededstale 53dpg 20

base8a045f760 Jul 28, 08:50 on master

applyapplied Jul 28, 15:28

rebaselast tried Jul 28, 15:28 on 8a045f760

pushJul 28, 15:29 -> 9d25a45ce branch diff vs base

patchsetdownload in thread

Result	Att	PG	Tests	Build / test	Image	When
tests failed	1	20	924 / 928	2m 47s / 5m 03s	`docker run ... @sha256:3b42399...`	Jul 28, 15:42
run 30373587570 failed: regress/sysviews, test_plan_advice/001_replan_regress, pg_upgrade/002_pg_upgrade, recovery/027_stream_regress executed 928 - ccache 166 hit / 6452 miss - head 9d25a45ce - digest sha256:3b423997a49201... - run 30373587570
tests failed	1	20	926 / 930	2m 54s / 5m 01s	`docker run ... @sha256:c4d65a0...`	Jul 27, 00:28
run 30227146325 failed: regress/sysviews, test_plan_advice/001_replan_regress, pg_upgrade/002_pg_upgrade, recovery/027_stream_regress executed 930 - ccache 166 hit / 6452 miss - head 70df1d29c - digest sha256:c4d65a09e5f504... - run 30227146325