hashjoins vs. Bloom filters (yet again)

back to CI dashboard

6 patchsets tracked - current t139791_73

v73t139791_73posted Sep 05, 16:44never appliedstale 47dpg 20apply failed
v70t139791_70posted Aug 24, 08:39supersededstale 59dpg 20apply failed
v55t139791_55posted Aug 09, 16:01supersededstale 3mopg 20apply failed
v49t139791_49posted Jul 30, 19:00tests failedsupersededstale 59dpg 20
base8646214ee Aug 24, 07:46 on master
applyapplied Aug 24, 10:05
rebaselast tried Sep 22, 15:57 on e8a3ee5b1
Applying: PoC: hashjoin bloom filter pushdown
Using index info to reconstruct a base tree...
M	contrib/pg_plan_advice/expected/join_order.out
M	contrib/postgres_fdw/expected/postgres_fdw.out
M	src/backend/commands/explain.c
M	src/backend/executor/execUtils.c
M	src/backend/executor/nodeIndexonlyscan.c
M	src/backend/executor/nodeIndexscan.c
M	src/backend/executor/nodeTidscan.c
M	src/backend/optimizer/path/allpaths.c
M	src/backend/optimizer/path/costsize.c
M	src/backend/optimizer/path/equivclass.c
M	src/backend/optimizer/path/joinpath.c
M	src/backend/optimizer/plan/createplan.c
M	src/backend/optimizer/plan/planner.c
M	src/backend/optimizer/plan/setrefs.c
M	src/backend/optimizer/util/pathnode.c
M	src/backend/utils/misc/guc_parameters.dat
M	src/backend/utils/misc/postgresql.conf.sample
M	src/include/executor/executor.h
M	src/include/nodes/execnodes.h
M	src/include/nodes/pathnodes.h
M	src/include/nodes/plannodes.h
M	src/include/optimizer/cost.h
M	src/include/optimizer/pathnode.h
M	src/include/optimizer/paths.h
M	src/test/regress/expected/aggregates.out
A	src/test/regress/expected/graph_table.out
M	src/test/regress/expected/join.out
M	src/test/regress/expected/misc_functions.out
M	src/test/regress/expected/privileges.out
M	src/test/regress/expected/returning.out
M	src/test/regress/expected/rowsecurity.out
M	src/test/regress/expected/stats_ext.out
M	src/test/regress/expected/subselect.out
M	src/test/regress/expected/updatable_views.out
M	src/test/regress/sql/rowsecurity.sql
M	src/tools/pgindent/typedefs.list
Falling back to patching base and 3-way merge...
Auto-merging src/tools/pgindent/typedefs.list
Auto-merging src/test/regress/sql/rowsecurity.sql
Auto-merging src/test/regress/expected/updatable_views.out
Auto-merging src/test/regress/expected/subselect.out
Auto-merging src/test/regress/expected/stats_ext.out
Auto-merging src/test/regress/expected/rowsecurity.out
Auto-merging src/test/regress/expected/returning.out
Auto-merging src/test/regress/expected/privileges.out
Auto-merging src/test/regress/expected/misc_functions.out
Auto-merging src/test/regress/expected/join.out
CONFLICT (content): Merge conflict in src/test/regress/expected/join.out
CONFLICT (modify/delete): src/test/regress/expected/graph_table.out deleted in HEAD and modified in PoC: hashjoin bloom filter pushdown. Version PoC: hashjoin bloom filter pushdown of src/test/regress/expected/graph_table.out left in tree.
Auto-merging src/test/regress/expected/aggregates.out
Auto-merging src/include/optimizer/paths.h
Auto-merging src/include/optimizer/pathnode.h
Auto-merging src/include/optimizer/cost.h
Auto-merging src/include/nodes/plannodes.h
Auto-merging src/include/nodes/pathnodes.h
Auto-merging src/include/nodes/execnodes.h
Auto-merging src/include/executor/executor.h
Auto-merging src/backend/utils/misc/postgresql.conf.sample
Auto-merging src/backend/utils/misc/guc_parameters.dat
Auto-merging src/backend/optimizer/util/pathnode.c
Auto-merging src/backend/optimizer/plan/setrefs.c
Auto-merging src/backend/optimizer/plan/planner.c
Auto-merging src/backend/optimizer/plan/createplan.c
Auto-merging src/backend/optimizer/path/joinpath.c
Auto-merging src/backend/optimizer/path/equivclass.c
Auto-merging src/backend/optimizer/path/costsize.c
Auto-merging src/backend/optimizer/path/allpaths.c
Auto-merging src/backend/executor/nodeTidscan.c
Auto-merging src/backend/executor/nodeIndexscan.c
Auto-merging src/backend/executor/nodeIndexonlyscan.c
Auto-merging src/backend/executor/execUtils.c
Auto-merging src/backend/commands/explain.c
CONFLICT (content): Merge conflict in src/backend/commands/explain.c
Auto-merging contrib/postgres_fdw/expected/postgres_fdw.out
Auto-merging contrib/pg_plan_advice/expected/join_order.out
Patch failed at 0001 PoC: hashjoin bloom filter pushdown

error: Failed to merge in the changes.
hint: Use 'git am --show-current-patch=diff' to see the failed patch
hint: When you have resolved this problem, run "git am --continue".
hint: If you prefer to skip this patch, run "git am --skip" instead.
hint: To restore the original branch and stop patching, run "git am --abort".
hint: Disable this message with "git config advice.mergeConflict false"
conflicts on master: src/test/regress/expected/join.out, src/test/regress/expected/graph_table.out, src/backend/commands/explain.c
pushAug 24, 10:05 -> 442996c2cbranchdiff vs base
ResultAttPGTestsBuild / testImageWhen
tests failed1201026 / 10272m 56s / 5m 39sdocker run ... :t139791Aug 24, 10:17
run 32715032844
failed: recovery/027_stream_regress
executed 1027 - ccache 98 hit / 6526 miss - head 442996c2c - digest sha256:009b316af24360... - run 32715032844
success1201027 / 10272m 41s / 5m 08sdocker run ... @sha256:626842b...Aug 23, 10:16
run 32632769193
executed 1027 - ccache 98 hit / 6526 miss - head 0bf635cdc - digest sha256:626842bfc87863... - run 32632769193
tests failed1201026 / 10272m 14s / 5m 11sdocker run ... @sha256:04c8001...Aug 22, 10:13
run 32566613982
failed: recovery/027_stream_regress
executed 1027 - ccache 98 hit / 6526 miss - head adfc56d5b - digest sha256:04c8001721b1da... - run 32566613982
tests failed1201026 / 10272m 48s / 5m 55sdocker run ... @sha256:dadd019...Aug 21, 10:14
run 32470792189
failed: recovery/027_stream_regress
executed 1027 - ccache 98 hit / 6526 miss - head b15758dbb - digest sha256:dadd0195f9cdfe... - run 32470792189
success1201027 / 10272m 16s / 4m 38sdocker run ... @sha256:ed17929...Aug 20, 10:10
run 32356821109
executed 1027 - ccache 98 hit / 6526 miss - head e1f0d0a39 - digest sha256:ed1792996162e2... - run 32356821109
success1201027 / 10272m 55s / 5m 44sdocker run ... @sha256:ab44b48...Aug 19, 10:16
run 32240400437
executed 1027 - ccache 98 hit / 6526 miss - head 3eb96ce20 - digest sha256:ab44b48d23862e... - run 32240400437
cancelled1----Aug 19, 09:59
run 32240398480
head 3eb96ce20 - run 32240398480
success1201025 / 10252m 45s / 4m 50sdocker run ... @sha256:f90b8e7...Aug 18, 10:05
run 32124071744
executed 1025 - ccache 98 hit / 6525 miss - head 8d82d36d4 - digest sha256:f90b8e7dfdae21... - run 32124071744
tests failed1201022 / 10233m 00s / 6m 03sdocker run ... @sha256:3365b5c...Aug 17, 10:04
run 32017454650
failed: recovery/027_stream_regress
executed 1023 - ccache 98 hit / 6525 miss - head de00b31dd - digest sha256:3365b5c28caeb0... - run 32017454650
tests failed1201022 / 10232m 58s / 6m 06sdocker run ... @sha256:9953a4b...Aug 16, 10:03
run 31940165490
failed: recovery/027_stream_regress
executed 1023 - ccache 98 hit / 6525 miss - head afd9a6514 - digest sha256:9953a4bcf56ff6... - run 31940165490
tests failed1201022 / 10232m 10s / 4m 37sdocker run ... @sha256:da643ad...Aug 15, 09:59
run 31878014263
failed: recovery/027_stream_regress
executed 1023 - ccache 98 hit / 6525 miss - head fc4d5861a - digest sha256:da643ad1fbfdae... - run 31878014263
tests failed1201022 / 10232m 51s / 5m 47sdocker run ... @sha256:22c8b6d...Aug 14, 10:00
run 31789664291
failed: recovery/027_stream_regress
executed 1023 - ccache 165 hit / 6458 miss - head fbddbd69c - digest sha256:22c8b6d558d6ef... - run 31789664291
tests failed1201022 / 10232m 54s / 5m 48sdocker run ... @sha256:55f6c19...Aug 13, 10:04
run 31688240340
failed: recovery/027_stream_regress
executed 1023 - ccache 165 hit / 6458 miss - head 0e2fcb2cf - digest sha256:55f6c19ecc9967... - run 31688240340
tests failed1201022 / 10232m 47s / 5m 22sdocker run ... @sha256:bae3a33...Aug 12, 10:02
run 31584446461
failed: recovery/027_stream_regress
executed 1023 - ccache 165 hit / 6458 miss - head 2194d3d9d - digest sha256:bae3a332c150e1... - run 31584446461
success1201023 / 10232m 56s / 6m 02sdocker run ... @sha256:9f133e5...Aug 11, 09:56
run 31479000374
executed 1023 - ccache 165 hit / 6454 miss - head 9364710fc - digest sha256:9f133e5e0b1f6b... - run 31479000374
tests failed1201022 / 10232m 26s / 4m 44sdocker run ... @sha256:a50f182...Aug 10, 09:53
run 31375439019
failed: recovery/027_stream_regress
executed 1023 - ccache 166 hit / 6453 miss - head e0107019d - digest sha256:a50f182d093e7d... - run 31375439019
tests failed1201022 / 10232m 52s / 5m 49sdocker run ... @sha256:a21c4bb...Aug 08, 12:03
run 31255960572
failed: recovery/027_stream_regress
executed 1023 - ccache 166 hit / 6453 miss - head eb1453930 - digest sha256:a21c4bb41592ef... - run 31255960572
tests failed1201022 / 10232m 47s / 5m 23sdocker run ... @sha256:177314d...Aug 07, 12:01
run 31175693277
failed: recovery/027_stream_regress
executed 1023 - ccache 166 hit / 6453 miss - head c671304f6 - digest sha256:177314d127a402... - run 31175693277
success1201022 / 10222m 52s / 5m 39sdocker run ... @sha256:d65dbf3...Aug 06, 12:01
run 31098831115
executed 1022 - ccache 166 hit / 6453 miss - head 636d60e48 - digest sha256:d65dbf36fedb44... - run 31098831115
tests failed1201021 / 10222m 54s / 5m 35sdocker run ... @sha256:5cf9eb8...Aug 05, 12:03
run 31002966055
failed: recovery/027_stream_regress
executed 1022 - ccache 166 hit / 6453 miss - head bf383e44a - digest sha256:5cf9eb8eeb9979... - run 31002966055
success1201022 / 10222m 45s / 5m 09sdocker run ... @sha256:0eca390...Aug 04, 12:05
run 30906241013
executed 1022 - ccache 166 hit / 6453 miss - head 3a62ab843 - digest sha256:0eca390ee89dc5... - run 30906241013
success1201021 / 10211m 50s / 4m 18sdocker run ... @sha256:6ae28d5...Aug 03, 11:56
run 30810723427
executed 1021 - ccache 166 hit / 6453 miss - head 13376ea55 - digest sha256:6ae28d5e3d430a... - run 30810723427
success1201021 / 10212m 38s / 4m 57sdocker run ... @sha256:f367ac2...Aug 02, 11:58
run 30746295939
executed 1021 - ccache 166 hit / 6453 miss - head 06848d48e - digest sha256:f367ac21e0aba9... - run 30746295939
success1201021 / 10212m 56s / 5m 53sdocker run ... @sha256:869b538...Aug 01, 11:57
run 30698216141
executed 1021 - ccache 166 hit / 6453 miss - head abb6bf1fa - digest sha256:869b5382720f9d... - run 30698216141
tests failed1201019 / 10202m 57s / 5m 57sdocker run ... @sha256:9a7f32e...Jul 31, 11:58
run 30627888029
failed: recovery/027_stream_regress
executed 1020 - ccache 166 hit / 6453 miss - head d5c97b9bc - digest sha256:9a7f32e2850fac... - run 30627888029
v45t139791_45posted Jul 28, 14:27tests failedsupersededstale 3mopg 20
base6aba42c66 Jul 30, 19:47 on master
applyapplied Jul 30, 21:29
rebaselast tried Jul 30, 21:29 on 6aba42c66
pushJul 30, 21:29 -> b2a677ca4branchdiff vs base
ResultAttPGTestsBuild / testImageWhen
tests failed120930 / 9322m 46s / 5m 08sdocker run ... @sha256:80268c8...Jul 30, 21:40
run 30583613227
failed: pg_plan_advice/join_order, recovery/051_effective_wal_level
executed 932 - ccache 166 hit / 6453 miss - head b2a677ca4 - digest sha256:80268c82d9d4ed... - run 30583613227
tests failed120930 / 9312m 55s / 5m 06sdocker run ... @sha256:f08df0b...Jul 29, 21:40
run 30492526414
failed: pg_plan_advice/join_order
executed 931 - ccache 166 hit / 6446 miss - head 5ee00a241 - digest sha256:f08df0be76171f... - run 30492526414
tests failed120930 / 9312m 56s / 5m 24sdocker run ... @sha256:46f659e...Jul 28, 21:40
run 30400795469
failed: pg_plan_advice/join_order
executed 931 - ccache 166 hit / 6453 miss - head a9db348d7 - digest sha256:46f659e511abee... - run 30400795469
v7t139791_7posted Jun 02, 15:22tests failedsupersededstale 3mopg 20
base8a045f760 Jul 28, 08:50 on master
applyapplied Jul 28, 14:53
rebaselast tried Jul 28, 14:53 on 8a045f760
pushJul 28, 14:53 -> 08340038abranchdiff vs base
ResultAttPGTestsBuild / testImageWhen
tests failed120680 / 6832m 53s / 4m 58sdocker run ... @sha256:9b8a26c...Jul 28, 15:04
run 30370617561
failed: test_plan_advice/001_replan_regress, pg_upgrade/002_pg_upgrade, recovery/027_stream_regress
executed 683 - ccache 166 hit / 6452 miss - head 08340038a - digest sha256:9b8a26ca341b6c... - run 30370617561