Horton

Track scan reversals in MergeJoin

Peter Eisentraut <peter@eisentraut.org>

View on postgr.es
Commit: c594f1ad2ba7cbe66e8ae98da4ffed06491d1082
Author: Peter Eisentraut <peter@eisentraut.org>
Date: 2024-10-14T13:36:18Z
Releases: 18.0 
Track scan reversals in MergeJoin

The MergeJoin struct was tracking "mergeStrategies", which were an
array of btree strategy numbers, purely for the purpose of comparing
it later against btree strategies to determine if the scan direction
was forward or reverse.  Change that.  Instead, track
"mergeReversals", an array of bool, to indicate the same without an
unfortunate assumption that a strategy number refers specifically to a
btree strategy.

Author: Mark Dilger <mark.dilger@enterprisedb.com>
Discussion: https://www.postgresql.org/message-id/flat/E72EAA49-354D-4C2E-8EB9-255197F55330@enterprisedb.com

Files

PathChange+/−
src/backend/executor/nodeMergejoin.c modified +4 −9
src/backend/optimizer/plan/createplan.c modified +7 −7
src/include/nodes/plannodes.h modified +1 −1

Discussion