Improve the performance of nested loop join in the case of partitioned inner table

back to CI dashboard

1 patchset tracked - current t47641_1

v1t47641_1posted Mar 23, 2023tests failedwon't retryancient 4ypg 16
basec8e1ba736 Jan 02, 2023 - 1356 days / 10199 commits behind master (from history)
applyapplied Jul 26, 07:24
pushJul 28, 00:42 -> 4f9171aa9branchdiff vs base
ResultAttPGTestsBuild / testImageWhen
tests failed116267 / 4420m 10s / 0m 56sdocker run ... :t47641Jul 28, 00:51
run 30318096867
failed: regress/tablespace, regress/boolean, regress/char, regress/name, regress/varchar, regress/text, regress/int2, regress/int4, regress/int8, regress/oid, regress/float4, regress/float8, regress/bit, regress/numeric, regress/txid, regress/uuid, regress/enum, regress/money, regress/rangetypes, regress/pg_lsn, regress/regproc, regress/multirangetypes, regress/type_sanity, regress/opr_sanity, regress/expressions, regress/copy, regress/copyselect, regress/copydml, regress/insert, regress/insert_conflict, regress/create_function_c, regress/create_misc, regress/create_operator, regress/create_procedure, regress/create_table, regress/create_type, regress/create_index, regress/create_index_spgist, regress/create_view, regress/index_including, regress/index_including_gist, regress/create_function_sql, regress/constraints, regress/triggers, regress/select, regress/inherit, regress/vacuum, regress/updatable_views, regress/create_am, regress/sanity_check, regress/select_into, regress/select_distinct, regress/select_distinct_on, regress/select_implicit, regress/select_having, regress/subselect, regress/union, regress/case, regress/join, regress/aggregates, regress/transactions, regress/portals, regress/arrays, regress/btree_index, regress/hash_index, regress/update, regress/delete, regress/namespace, regress/prepared_xacts, regress/brin, regress/gin, regress/gist, regress/spgist, regress/privileges, regress/collate, regress/matview, regress/lock, regress/replica_identity, regress/rowsecurity, regress/object_address, regress/tablesample, regress/groupingsets, regress/identity, regress/generated, regress/brin_bloom, regress/brin_multi, regress/create_table_like, regress/alter_generic, regress/alter_operator, regress/misc, regress/async, regress/dbsize, regress/merge, regress/misc_functions, regress/sysviews, regress/tsrf, regress/tid, regress/tidscan, regress/tidrangescan, regress/collate.icu.utf8, regress/incremental_sort, regress/create_role, regress/rules, regress/psql, regress/psql_crosstab, regress/amutils, regress/stats_ext, regress/collate.linux.utf8, regress/select_parallel, regress/write_parallel, regress/vacuum_parallel, regress/publication, regress/subscription, regress/select_views, regress/portals_p2, regress/foreign_key, regress/cluster, regress/dependency, regress/guc, regress/bitmapops, regress/combocid, regress/tsearch, regress/tsdicts, regress/foreign_data, regress/window, regress/xmlmap, regress/functional_deps, regress/advisory_lock, regress/indirect_toast, regress/equivclass, regress/json, regress/jsonb, regress/json_encoding, regress/jsonpath, regress/jsonpath_encoding, regress/jsonb_jsonpath, regress/plancache, regress/limit, regress/plpgsql, regress/copy2, regress/temp, regress/domain, regress/rangefuncs, regress/prepare, regress/conversion, regress/truncate, regress/alter_table, regress/sequence, regress/polymorphism, regress/rowtypes, regress/returning, regress/largeobject, regress/with, regress/xml, regress/partition_join, regress/partition_prune, regress/reloptions, regress/hash_part, regress/indexing, regress/partition_aggregate, regress/partition_info, regress/tuplesort, regress/explain, regress/compression, regress/memoize, regress/stats, regress/event_trigger, regress/oidjoins, regress/fast_default, tap/002_nonesuch, tap/003_check, regress/eval-plan-qual, regress/earthdistance, pg_amcheck/002_nonesuch, pg_amcheck/003_check
executed 442 - ccache 1571 hit / 2981 miss - head 4f9171aa9 - digest sha256:b348fa44ac995f... - run 30318096867