Thread: pgsql/src include/optimizer/cost.h include/opt ...

pgsql/src include/optimizer/cost.h include/opt ...

From
Tom Lane
Date:
CVSROOT:    /home/projects/pgsql/cvsroot
Module name:    pgsql
Changes by:    tgl@hub.org    01/02/15 19:03:08

Modified files:
    src/include/optimizer: cost.h pathnode.h
    src/backend/optimizer/path: costsize.c joinrels.c
    src/backend/optimizer/util: relnode.c

Log message:
    Take OUTER JOIN semantics into account when estimating the size of join
    relations.  It's not very bright, but at least it now knows that
    A LEFT JOIN B must produce at least as many rows as are in A ...