Is there value in having optimizer stats for joins/foreignkeys?

back to CI dashboard

3 patchsets tracked - current t52787_42

v42t52787_42posted Aug 03, 23:06successneeds rebaserecent 15dpg 20
baseb91f79cd0 Aug 10, 00:01 on master
applyapplied Aug 10, 05:49
rebaselast tried about 22 hours ago on 9673a0aa9
Applying: Unify extended statistics columns and expressions into a single stxexprs list
Using index info to reconstruct a base tree...
M	doc/src/sgml/perform.sgml
M	src/backend/catalog/system_views.sql
M	src/backend/commands/statscmds.c
M	src/backend/optimizer/util/plancat.c
M	src/backend/parser/parse_utilcmd.c
M	src/backend/statistics/dependencies.c
M	src/backend/statistics/extended_stats.c
M	src/backend/statistics/mcv.c
M	src/backend/statistics/mvdistinct.c
M	src/backend/utils/adt/ruleutils.c
M	src/backend/utils/adt/selfuncs.c
M	src/bin/psql/describe.c
M	src/include/catalog/pg_proc.dat
M	src/include/nodes/pathnodes.h
M	src/test/regress/expected/rules.out
M	src/test/regress/expected/stats_ext.out
M	src/test/regress/expected/stats_import.out
M	src/test/regress/sql/stats_ext.sql
M	src/test/regress/sql/stats_import.sql
Falling back to patching base and 3-way merge...
Auto-merging src/test/regress/sql/stats_import.sql
Auto-merging src/test/regress/sql/stats_ext.sql
Auto-merging src/test/regress/expected/stats_import.out
Auto-merging src/test/regress/expected/stats_ext.out
Auto-merging src/test/regress/expected/rules.out
Auto-merging src/include/nodes/pathnodes.h
Auto-merging src/include/catalog/pg_proc.dat
Auto-merging src/bin/psql/describe.c
Auto-merging src/backend/utils/adt/selfuncs.c
Auto-merging src/backend/utils/adt/ruleutils.c
Auto-merging src/backend/statistics/mvdistinct.c
Auto-merging src/backend/statistics/mcv.c
Auto-merging src/backend/statistics/extended_stats.c
Auto-merging src/backend/statistics/dependencies.c
Auto-merging src/backend/parser/parse_utilcmd.c
Auto-merging src/backend/optimizer/util/plancat.c
Auto-merging src/backend/commands/statscmds.c
CONFLICT (content): Merge conflict in src/backend/commands/statscmds.c
Auto-merging src/backend/catalog/system_views.sql
Auto-merging doc/src/sgml/perform.sgml
Patch failed at 0001 Unify extended statistics columns and expressions into a single stxexprs list

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/backend/commands/statscmds.c
pushAug 10, 05:49 -> a9728a66ebranchdiff vs base
ResultAttPGTestsBuild / testImageWhen
success1201020 / 10202m 49s / 5m 17sdocker run ... :t52787Aug 10, 06:00
run 31359809629
executed 1020 - ccache 166 hit / 6453 miss - head a9728a66e - digest sha256:dc1f32acc9b995... - run 31359809629
success1201020 / 10202m 50s / 5m 23sdocker run ... @sha256:d5669f7...Aug 08, 04:39
run 31239470176
executed 1020 - ccache 166 hit / 6453 miss - head 7d4b3b8b8 - digest sha256:d5669f785a7405... - run 31239470176
success1201019 / 10193m 16s / 5m 53sdocker run ... @sha256:3d54d52...Aug 07, 04:38
run 31147369537
executed 1019 - ccache 166 hit / 6453 miss - head 24a2ee0c9 - digest sha256:3d54d52c8dd98e... - run 31147369537
success1201019 / 10192m 44s / 4m 44sdocker run ... @sha256:e034210...Aug 05, 23:22
run 31055454156
executed 1019 - ccache 166 hit / 6453 miss - head 7fd066cd2 - digest sha256:e034210d4b86ab... - run 31055454156
success1201019 / 10192m 12s / 4m 37sdocker run ... @sha256:2072a92...Aug 04, 23:21
run 30959046888
executed 1019 - ccache 166 hit / 6453 miss - head 324a9d074 - digest sha256:2072a9251ca395... - run 30959046888
success1201019 / 10192m 53s / 5m 25sdocker run ... @sha256:cbb0763...Aug 03, 23:21
run 30861244339
executed 1019 - ccache 166 hit / 6453 miss - head 638eb65db - digest sha256:cbb07637d85e56... - run 30861244339
v38t52787_38posted Jun 23, 11:02successsupersededrecent 22dpg 20
base4e68b7e29 Aug 02, 20:49 on master
applyapplied Aug 03, 00:02
rebaselast tried Aug 03, 00:02 on 4e68b7e29
pushAug 03, 00:02 -> dea5e3457branchdiff vs base
ResultAttPGTestsBuild / testImageWhen
success1201018 / 10182m 17s / 4m 15sdocker run ... @sha256:f15415e...Aug 03, 00:12
run 30773538828
executed 1018 - ccache 166 hit / 6453 miss - head dea5e3457 - digest sha256:f15415e594cc9d... - run 30773538828
success1201018 / 10182m 55s / 4m 58sdocker run ... @sha256:0a89f5d...Aug 02, 00:12
run 30724457413
executed 1018 - ccache 166 hit / 6453 miss - head 697912086 - digest sha256:0a89f5d1755f54... - run 30724457413
success1201018 / 10182m 55s / 5m 37sdocker run ... @sha256:682fe53...Aug 01, 00:11
run 30674397509
executed 1018 - ccache 166 hit / 6453 miss - head ba603aabb - digest sha256:682fe532da7f54... - run 30674397509
success1201017 / 10171m 53s / 3m 51sdocker run ... @sha256:ea83513...Jul 31, 00:07
run 30592170610
executed 1017 - ccache 166 hit / 6453 miss - head 2f77642ac - digest sha256:ea83513de9dada... - run 30592170610
success1201017 / 10172m 46s / 5m 16sdocker run ... @sha256:dc68c7e...Jul 30, 00:08
run 30501216606
executed 1017 - ccache 166 hit / 6453 miss - head 5c06e6b6e - digest sha256:dc68c7e31a97db... - run 30501216606
success1201016 / 10162m 59s / 5m 26sdocker run ... @sha256:f64de25...Jul 29, 00:09
run 30409607689
executed 1016 - ccache 166 hit / 6453 miss - head 31449be25 - digest sha256:f64de251d00bba... - run 30409607689
v26t52787_26posted May 15, 15:30successsupersededstale 3mopg 19
basec7cb8e5b7 May 13, 14:54 - 103 days / 888 commits behind master (from history)
applyapplied Jul 26, 07:18
pushJul 27, 00:12 -> 48ae85b7abranchdiff vs base
ResultAttPGTestsBuild / testImageWhen
success1191003 / 10032m 58s / 5m 18sdocker run ... @sha256:67e0b0a...Jul 27, 00:25
run 30226892973
executed 1003 - ccache 145 hit / 6475 miss - head 48ae85b7a - digest sha256:67e0b0ae049995... - run 30226892973