pgsql/src backend/executor/nodeMergejoin.c bac ... - Mailing list pgsql-committers

From tgl@postgresql.org (Tom Lane)
Subject pgsql/src backend/executor/nodeMergejoin.c bac ...
Date
Msg-id 20020301040929.1A25547599C@postgresql.org
Whole thread Raw
List pgsql-committers
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.


pgsql-committers by date:

Previous
From: "Yannick ALLUSSE"
Date:
Subject: SIze Of the Database
Next
From: tgl@postgresql.org (Tom Lane)
Date:
Subject: pgsql/src backend/nodes/copyfuncs.c backend/no ...