git.postgresql.org Git - postgresql.git/commit

git projects / postgresql.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 216a784) | patch
Allow left join removals and unique joins on partitioned tables
Mon, 9 Jan 2023 04:15:08 +0000 (17:15 +1300)
Mon, 9 Jan 2023 04:15:08 +0000 (17:15 +1300)
commit 3c569049b7b502bb4952483d19ce622ff0af5fd6
Allow left join removals and unique joins on partitioned tables

This allows left join removals and unique joins to work with partitioned
tables. The planner just lacked sufficient proofs that a given join
would not cause any row duplication. Unique indexes currently serve as
that proof, so have get_relation_info() populate the indexlist for
partitioned tables too.

Author: Arne Roland
Reviewed-by: Alvaro Herrera, Zhihong Yu, Amit Langote, David Rowley
Discussion: https://postgr.es/m/c3b2408b7a39433b8230bbcd02e9f302@index.de
src/backend/optimizer/util/plancat.c diff | blob | blame | history
src/backend/utils/adt/selfuncs.c diff | blob | blame | history
src/include/nodes/pathnodes.h diff | blob | blame | history
src/test/regress/expected/join.out diff | blob | blame | history
src/test/regress/expected/partition_join.out diff | blob | blame | history
src/test/regress/sql/join.sql diff | blob | blame | history
src/test/regress/sql/partition_join.sql diff | blob | blame | history
This is the main PostgreSQL git repository.
RSS Atom

AltStyle によって変換されたページ (->オリジナル) /