]> granicus.if.org Git - postgresql/commit
Add extensive tests for partition pruning.
authorRobert Haas <rhaas@postgresql.org>
Wed, 29 Nov 2017 20:19:07 +0000 (15:19 -0500)
committerRobert Haas <rhaas@postgresql.org>
Wed, 29 Nov 2017 20:25:29 +0000 (15:25 -0500)
commit8d4e70a63bf8772bbf5db620ef1e14761fbd2044
tree8ce39f866d700f804695d9755de3b55bb842b5f0
parentc7f5c58e1c6bb250ff7c24970a05e033201be409
Add extensive tests for partition pruning.

Currently, partition pruning happens via constraint exclusion, but
there are pending places to replace that with a different and
hopefully faster mechanism.  To be sure that we don't change behavior
without realizing it, add extensive test coverage.

Note that not all of these behaviors are optimal; in some cases,
partitions are not pruned even though it would be safe to do so.
These tests therefore serve to memorialize the current state rather
than the ideal state.  Patches that improve things can update the test
results as appropriate.

Amit Langote, adjusted by me.  Review and testing of the larger patch
set of which this is a part by Ashutosh Bapat, David Rowley, Dilip
Kumar, Jesper Pedersen, Rajkumar Raghuwanshi, Beena Emerson, Amul Sul,
and Kyotaro Horiguchi.

Discussion: http://postgr.es/m/098b9c71-1915-1a2a-8d52-1a7a50ce79e8@lab.ntt.co.jp
src/test/regress/expected/partition_prune.out [new file with mode: 0644]
src/test/regress/parallel_schedule
src/test/regress/serial_schedule
src/test/regress/sql/partition_prune.sql [new file with mode: 0644]