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