BUG #19708: Hash Join becomes about 300x slower with higher work_mem

back to CI dashboard

1 patchset tracked - current t253869_3

v3t253869_3posted Sep 20, 20:52successappliesrecent 0dpg 20
base9b5d4e333 about 22 hours ago on master
applyapplied about 1 hour ago
rebaselast tried about 1 hour ago on 9b5d4e333
pushabout 1 hour ago -> 4e36476f8branchdiff vs base
ResultAttPGTestsBuild / testImageWhen
success1201070 / 10701m 55s / 4m 50sdocker run ... :t253869about 1 hour ago
run 45039390880
executed 1070 - ccache 78 hit / 6547 miss - head 4e36476f8 - digest sha256:a9622e6663aebd... - run 45039390880
success1201070 / 10703m 02s / 5m 28sdocker run ... @sha256:8c34d84...1 day ago
run 44920116700
executed 1070 - ccache 78 hit / 6547 miss - head 5fc3df9e3 - digest sha256:8c34d84ef856a9... - run 44920116700
success1201069 / 10693m 06s / 5m 58sdocker run ... @sha256:a13c64c...2 days ago
run 44764879254
executed 1069 - ccache 78 hit / 6547 miss - head e0319c7de - digest sha256:a13c64c0a94113... - run 44764879254
success1201068 / 10681m 44s / 4m 09sdocker run ... @sha256:2f23c1e...3 days ago
run 44555699952
executed 1068 - ccache 78 hit / 6547 miss - head 6c5d96308 - digest sha256:2f23c1e17f2e8d... - run 44555699952
success1201067 / 10672m 45s / 4m 41sdocker run ... @sha256:2680527...4 days ago
run 44336401522
executed 1067 - ccache 78 hit / 6547 miss - head 6ff13de09 - digest sha256:26805278fd2234... - run 44336401522
success1201067 / 10672m 19s / 4m 55sdocker run ... @sha256:2b18ed2...5 days ago
run 44112191990
executed 1067 - ccache 78 hit / 6547 miss - head 300e5683a - digest sha256:2b18ed2045a4a7... - run 44112191990
success1201067 / 10673m 04s / 5m 39sdocker run ... @sha256:ac450c1...6 days ago
run 43893158659
executed 1067 - ccache 78 hit / 6547 miss - head 823825d71 - digest sha256:ac450c1aa9f1ed... - run 43893158659
success1201067 / 10671m 59s / 3m 46sdocker run ... @sha256:4f3911a...Nov 15, 10:54
run 43705676503
executed 1067 - ccache 78 hit / 6547 miss - head d9e867818 - digest sha256:4f3911a2ccdc17... - run 43705676503
success1201067 / 10673m 02s / 5m 42sdocker run ... @sha256:77fb673...Nov 14, 10:56
run 43586779014
executed 1067 - ccache 78 hit / 6547 miss - head 6f5fe0bd9 - digest sha256:77fb673befdcbb... - run 43586779014
success1201067 / 10671m 56s / 4m 41sdocker run ... @sha256:eecb175...Nov 13, 10:51
run 43411242179
executed 1067 - ccache 78 hit / 6547 miss - head 8e91e2603 - digest sha256:eecb175cf4ca7f... - run 43411242179
success1201067 / 10673m 03s / 5m 42sdocker run ... @sha256:a615bb8...Nov 12, 10:53
run 43202730318
executed 1067 - ccache 78 hit / 6547 miss - head c541a1377 - digest sha256:a615bb81afbeaf... - run 43202730318
success1201067 / 10672m 19s / 4m 27sdocker run ... @sha256:52ef6db...Nov 11, 10:47
run 43005255179
executed 1067 - ccache 78 hit / 6547 miss - head e4fb18372 - digest sha256:52ef6db89d0cde... - run 43005255179
success1201067 / 10673m 00s / 5m 28sdocker run ... @sha256:c3bc1b7...Nov 10, 10:47
run 42800631691
executed 1067 - ccache 78 hit / 6547 miss - head 699e69d82 - digest sha256:c3bc1b76780120... - run 42800631691
success1201053 / 10532m 17s / 4m 32sdocker run ... @sha256:beb7814...Nov 09, 10:44
run 42601991563
executed 1053 - ccache 78 hit / 6546 miss - head 4adaef39f - digest sha256:beb78143fcad81... - run 42601991563
success1201053 / 10532m 53s / 5m 06sdocker run ... @sha256:d9e01a4...Nov 06, 10:42
run 42203384458
executed 1053 - ccache 78 hit / 6546 miss - head eb490e47e - digest sha256:d9e01a4941e064... - run 42203384458
success1201053 / 10532m 00s / 4m 14sdocker run ... @sha256:3280a74...Nov 05, 10:36
run 42010895341
executed 1053 - ccache 78 hit / 6546 miss - head e65350b94 - digest sha256:3280a742a3fb0c... - run 42010895341
success1201052 / 10523m 01s / 5m 39sdocker run ... @sha256:98edfe7...Nov 03, 10:34
run 41618804651
executed 1052 - ccache 78 hit / 6544 miss - head 47b7551f8 - digest sha256:98edfe7cbfe7eb... - run 41618804651
success1201052 / 10521m 53s / 4m 23sdocker run ... @sha256:eec888c...Nov 02, 10:27
run 41427799745
executed 1052 - ccache 78 hit / 6544 miss - head 8b5a1014a - digest sha256:eec888c506798b... - run 41427799745
success1201051 / 10513m 02s / 5m 37sdocker run ... @sha256:c69080c...Nov 01, 10:25
run 41296600456
executed 1051 - ccache 78 hit / 6544 miss - head 849f10e61 - digest sha256:c69080cd4023b8... - run 41296600456
success1201051 / 10512m 19s / 4m 45sdocker run ... @sha256:de75fcb...Oct 31, 10:21
run 41191784248
executed 1051 - ccache 78 hit / 6544 miss - head 84e48743d - digest sha256:de75fcbe368524... - run 41191784248
success1201051 / 10512m 59s / 5m 28sdocker run ... @sha256:7548663...Oct 30, 10:22
run 41038939159
executed 1051 - ccache 78 hit / 6544 miss - head b6292d148 - digest sha256:7548663c921074... - run 41038939159
success1201051 / 10513m 08s / 5m 53sdocker run ... @sha256:094ce60...Oct 29, 10:21
run 40855378002
executed 1051 - ccache 78 hit / 6544 miss - head d0d15cced - digest sha256:094ce609d2f31e... - run 40855378002
success1201051 / 10512m 01s / 4m 30sdocker run ... @sha256:2332818...Oct 28, 10:14
run 40669321325
executed 1051 - ccache 78 hit / 6544 miss - head f6a6683b0 - digest sha256:23328185f25850... - run 40669321325
success1201050 / 10502m 17s / 4m 33sdocker run ... @sha256:79b74f7...Oct 27, 10:12
run 40485379731
executed 1050 - ccache 78 hit / 6544 miss - head d1b13dd96 - digest sha256:79b74f7fc2e4d6... - run 40485379731
success1201050 / 10502m 14s / 4m 15sdocker run ... @sha256:481b8af...Oct 26, 10:08
run 40303890884
executed 1050 - ccache 78 hit / 6544 miss - head 0304a9686 - digest sha256:481b8af113228d... - run 40303890884
success1201050 / 10502m 12s / 4m 28sdocker run ... @sha256:db7e129...Oct 25, 10:06
run 40182780872
executed 1050 - ccache 78 hit / 6544 miss - head 80c2dce9f - digest sha256:db7e129609c419... - run 40182780872
success1201050 / 10502m 33s / 4m 44sdocker run ... @sha256:ac5177d...Oct 24, 10:05
run 40083883149
executed 1050 - ccache 78 hit / 6544 miss - head 4783e8e6a - digest sha256:ac5177d8832d62... - run 40083883149
success1201050 / 10502m 55s / 5m 36sdocker run ... @sha256:8a543ff...Oct 23, 10:05
run 39935216121
executed 1050 - ccache 78 hit / 6544 miss - head 476f82113 - digest sha256:8a543fff563ef7... - run 39935216121
success1201050 / 10502m 58s / 5m 27sdocker run ... @sha256:8e1234e...Oct 22, 09:56
run 39757862376
executed 1050 - ccache 78 hit / 6544 miss - head a6e77ae99 - digest sha256:8e1234e700cf5a... - run 39757862376
success1201049 / 10492m 59s / 5m 24sdocker run ... @sha256:b5d78e0...Oct 21, 09:52
run 39578913252
executed 1049 - ccache 78 hit / 6544 miss - head 57f167514 - digest sha256:b5d78e098a598c... - run 39578913252
success1201049 / 10492m 14s / 4m 37sdocker run ... @sha256:97cf7ee...Oct 20, 09:38
run 39401059272
executed 1049 - ccache 78 hit / 6544 miss - head bc9da870a - digest sha256:97cf7ee70528a0... - run 39401059272
success1201049 / 10492m 53s / 5m 29sdocker run ... @sha256:6069c95...Oct 19, 09:38
run 39230196225
executed 1049 - ccache 78 hit / 6544 miss - head 1b4a26cf7 - digest sha256:6069c95baac0d8... - run 39230196225
success1201049 / 10492m 54s / 5m 30sdocker run ... @sha256:dc402e7...Oct 18, 09:35
run 39115226397
executed 1049 - ccache 78 hit / 6544 miss - head 5ae5bc896 - digest sha256:dc402e7e8b5546... - run 39115226397
success1201049 / 10491m 44s / 4m 06sdocker run ... @sha256:96c8b33...Oct 17, 09:30
run 39020883606
executed 1049 - ccache 78 hit / 6544 miss - head a98b16e71 - digest sha256:96c8b33e2ecb2d... - run 39020883606
success1201049 / 10492m 11s / 4m 37sdocker run ... @sha256:38b90f7...Oct 16, 09:30
run 38879926414
executed 1049 - ccache 78 hit / 6544 miss - head 4748c2266 - digest sha256:38b90f77efddf3... - run 38879926414
success1201049 / 10492m 39s / 4m 50sdocker run ... @sha256:a972d04...Oct 15, 09:28
run 38711897198
executed 1049 - ccache 78 hit / 6544 miss - head 0cbe21a2c - digest sha256:a972d04cbc1fa6... - run 38711897198
success1201044 / 10442m 19s / 4m 44sdocker run ... @sha256:0075ab8...Oct 14, 09:25
run 38541080722
executed 1044 - ccache 78 hit / 6544 miss - head 404786102 - digest sha256:0075ab81bf0bb3... - run 38541080722
success1201044 / 10442m 15s / 4m 45sdocker run ... @sha256:19e8851...Oct 13, 09:20
run 38374374475
executed 1044 - ccache 78 hit / 6544 miss - head 16ddfa3e9 - digest sha256:19e88517877af7... - run 38374374475
success1201044 / 10442m 57s / 5m 37sdocker run ... @sha256:cee9a5d...Oct 12, 09:17
run 38227685931
executed 1044 - ccache 78 hit / 6544 miss - head 6bb5b3bc2 - digest sha256:cee9a5d9da15a5... - run 38227685931
success1201044 / 10442m 54s / 5m 27sdocker run ... @sha256:74946d7...Oct 11, 03:20
run 38107484539
executed 1044 - ccache 78 hit / 6544 miss - head ec0890ae0 - digest sha256:74946d7e417bb2... - run 38107484539
success1201042 / 10422m 56s / 5m 33sdocker run ... @sha256:5a3ad37...Oct 08, 03:17
run 37721100670
executed 1042 - ccache 78 hit / 6544 miss - head 2dc8c63ef - digest sha256:5a3ad377cc3297... - run 37721100670
success1201041 / 10411m 57s / 4m 16sdocker run ... @sha256:17ac786...Oct 07, 03:12
run 37565028118
executed 1041 - ccache 78 hit / 6544 miss - head 0cce410fa - digest sha256:17ac7862e2639f... - run 37565028118
success1201039 / 10392m 13s / 4m 48sdocker run ... @sha256:afa7596...Oct 06, 03:12
run 37407104495
executed 1039 - ccache 78 hit / 6544 miss - head 0a183ae64 - digest sha256:afa7596bf84411... - run 37407104495
success1201039 / 10392m 52s / 5m 21sdocker run ... @sha256:5de0cb3...Oct 05, 03:11
run 37257646371
executed 1039 - ccache 78 hit / 6544 miss - head 3cf86fd0b - digest sha256:5de0cb376d27e9... - run 37257646371
success1201039 / 10391m 41s / 4m 08sdocker run ... @sha256:c077711...Oct 04, 03:08
run 37172731426
executed 1039 - ccache 78 hit / 6544 miss - head 03bf733a5 - digest sha256:c0777116185c7e... - run 37172731426
success1201039 / 10391m 41s / 4m 10sdocker run ... @sha256:5221662...Oct 03, 03:06
run 37091633460
executed 1039 - ccache 78 hit / 6544 miss - head e88309e84 - digest sha256:5221662f0b4593... - run 37091633460
success1201039 / 10392m 55s / 5m 24sdocker run ... @sha256:0f54a1b...Oct 02, 03:09
run 36958016466
executed 1039 - ccache 78 hit / 6544 miss - head 3afc37f8f - digest sha256:0f54a1ba0a280f... - run 36958016466
success1201039 / 10392m 55s / 5m 29sdocker run ... @sha256:855cddd...Oct 01, 03:03
run 36807909644
executed 1039 - ccache 78 hit / 6544 miss - head f04d53992 - digest sha256:855cddd00580b7... - run 36807909644
success1201039 / 10392m 54s / 5m 34sdocker run ... @sha256:e2b155d...Sep 30, 03:00
run 36661636147
executed 1039 - ccache 78 hit / 6544 miss - head 41bd3fb46 - digest sha256:e2b155dc3118ba... - run 36661636147
success1201039 / 10392m 52s / 5m 29sdocker run ... @sha256:cff520e...Sep 29, 02:59
run 36514366698
executed 1039 - ccache 78 hit / 6544 miss - head d88029c37 - digest sha256:cff520eadcbf29... - run 36514366698
success1201039 / 10392m 58s / 5m 35sdocker run ... @sha256:9e53fd0...Sep 28, 02:58
run 36371162291
executed 1039 - ccache 78 hit / 6544 miss - head 0c4651b0b - digest sha256:9e53fd06d50f0e... - run 36371162291
success1201039 / 10392m 45s / 4m 44sdocker run ... @sha256:a811044...Sep 26, 22:12
run 36274944027
executed 1039 - ccache 78 hit / 6544 miss - head 9f47c2f5a - digest sha256:a811044b740faa... - run 36274944027
success1201039 / 10392m 55s / 5m 36sdocker run ... @sha256:71aa7bc...Sep 25, 22:11
run 36194536675
executed 1039 - ccache 78 hit / 6544 miss - head 99e8d1815 - digest sha256:71aa7bcc732760... - run 36194536675
success1201038 / 10382m 46s / 5m 23sdocker run ... @sha256:9173135...Sep 24, 22:10
run 36064820119
executed 1038 - ccache 78 hit / 6544 miss - head 11776aee4 - digest sha256:91731358baba0d... - run 36064820119
success1201036 / 10361m 55s / 4m 24sdocker run ... @sha256:c0fe306...Sep 23, 22:06
run 35925629031
executed 1036 - ccache 98 hit / 6524 miss - head dc37e2039 - digest sha256:c0fe306a5a446e... - run 35925629031
success1201036 / 10362m 51s / 5m 07sdocker run ... @sha256:4d1df97...Sep 22, 22:05
run 35789463421
executed 1036 - ccache 98 hit / 6524 miss - head f336b1b2f - digest sha256:4d1df97234c90d... - run 35789463421
success1201036 / 10361m 51s / 4m 29sdocker run ... @sha256:ba8bae5...Sep 21, 21:52
run 35658853621
executed 1036 - ccache 98 hit / 6524 miss - head 0c00ef79a - digest sha256:ba8bae5553f268... - run 35658853621
success1201036 / 10362m 54s / 5m 27sdocker run ... @sha256:1aac9a7...Sep 20, 21:05
run 35537033139
executed 1036 - ccache 98 hit / 6524 miss - head a286e17da - digest sha256:1aac9a7e0b8b77... - run 35537033139