Is there value in having optimizer stats for joins/foreignkeys?
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
| Result | Att | PG | Tests | Build / test | Image | When |
|---|---|---|---|---|---|---|
| success | 1 | 20 | 1020 / 1020 | 2m 49s / 5m 17s | docker run ... :t52787 | Aug 10, 06:00 |
run 31359809629executed 1020 - ccache 166 hit / 6453 miss - head a9728a66e - digest sha256:dc1f32acc9b995... - run 31359809629 | ||||||
| success | 1 | 20 | 1020 / 1020 | 2m 50s / 5m 23s | docker run ... @sha256:d5669f7... | Aug 08, 04:39 |
run 31239470176executed 1020 - ccache 166 hit / 6453 miss - head 7d4b3b8b8 - digest sha256:d5669f785a7405... - run 31239470176 | ||||||
| success | 1 | 20 | 1019 / 1019 | 3m 16s / 5m 53s | docker run ... @sha256:3d54d52... | Aug 07, 04:38 |
run 31147369537executed 1019 - ccache 166 hit / 6453 miss - head 24a2ee0c9 - digest sha256:3d54d52c8dd98e... - run 31147369537 | ||||||
| success | 1 | 20 | 1019 / 1019 | 2m 44s / 4m 44s | docker run ... @sha256:e034210... | Aug 05, 23:22 |
run 31055454156executed 1019 - ccache 166 hit / 6453 miss - head 7fd066cd2 - digest sha256:e034210d4b86ab... - run 31055454156 | ||||||
| success | 1 | 20 | 1019 / 1019 | 2m 12s / 4m 37s | docker run ... @sha256:2072a92... | Aug 04, 23:21 |
run 30959046888executed 1019 - ccache 166 hit / 6453 miss - head 324a9d074 - digest sha256:2072a9251ca395... - run 30959046888 | ||||||
| success | 1 | 20 | 1019 / 1019 | 2m 53s / 5m 25s | docker run ... @sha256:cbb0763... | Aug 03, 23:21 |
run 30861244339executed 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
| Result | Att | PG | Tests | Build / test | Image | When |
|---|---|---|---|---|---|---|
| success | 1 | 20 | 1018 / 1018 | 2m 17s / 4m 15s | docker run ... @sha256:f15415e... | Aug 03, 00:12 |
run 30773538828executed 1018 - ccache 166 hit / 6453 miss - head dea5e3457 - digest sha256:f15415e594cc9d... - run 30773538828 | ||||||
| success | 1 | 20 | 1018 / 1018 | 2m 55s / 4m 58s | docker run ... @sha256:0a89f5d... | Aug 02, 00:12 |
run 30724457413executed 1018 - ccache 166 hit / 6453 miss - head 697912086 - digest sha256:0a89f5d1755f54... - run 30724457413 | ||||||
| success | 1 | 20 | 1018 / 1018 | 2m 55s / 5m 37s | docker run ... @sha256:682fe53... | Aug 01, 00:11 |
run 30674397509executed 1018 - ccache 166 hit / 6453 miss - head ba603aabb - digest sha256:682fe532da7f54... - run 30674397509 | ||||||
| success | 1 | 20 | 1017 / 1017 | 1m 53s / 3m 51s | docker run ... @sha256:ea83513... | Jul 31, 00:07 |
run 30592170610executed 1017 - ccache 166 hit / 6453 miss - head 2f77642ac - digest sha256:ea83513de9dada... - run 30592170610 | ||||||
| success | 1 | 20 | 1017 / 1017 | 2m 46s / 5m 16s | docker run ... @sha256:dc68c7e... | Jul 30, 00:08 |
run 30501216606executed 1017 - ccache 166 hit / 6453 miss - head 5c06e6b6e - digest sha256:dc68c7e31a97db... - run 30501216606 | ||||||
| success | 1 | 20 | 1016 / 1016 | 2m 59s / 5m 26s | docker run ... @sha256:f64de25... | Jul 29, 00:09 |
run 30409607689executed 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
| Result | Att | PG | Tests | Build / test | Image | When |
|---|---|---|---|---|---|---|
| success | 1 | 19 | 1003 / 1003 | 2m 58s / 5m 18s | docker run ... @sha256:67e0b0a... | Jul 27, 00:25 |
run 30226892973executed 1003 - ccache 145 hit / 6475 miss - head 48ae85b7a - digest sha256:67e0b0ae049995... - run 30226892973 | ||||||