pgsql/src backend/executor/nodeMergejoin.c bac ...

Started by Tom Laneover 24 years ago1 messagescomitters
Jump to latest
#1Tom Lane
tgl@sss.pgh.pa.us

CVSROOT: /cvsroot
Module name: pgsql
Changes by: tgl@postgresql.org 02/02/28 23:09:28

Modified files:
src/backend/executor: nodeMergejoin.c
src/backend/optimizer/path: costsize.c
src/backend/utils/adt: selfuncs.c
src/backend/utils/cache: lsyscache.c
src/include/utils: lsyscache.h selfuncs.h

Log message:
Teach planner about the idea that a mergejoin won't necessarily read
both input streams to the end. If one variable's range is much less
than the other, an indexscan-based merge can win by not scanning all
of the other table. Per example from Reinhard Max.