Обсуждение: pgsql/src/include/optimizer (paths.h planmain.h)

Поиск
Список
Период
Сортировка

pgsql/src/include/optimizer (paths.h planmain.h)

От
Tom Lane
Дата:
  Date: Sunday, July 23, 2000 @ 23:10:54
Author: tgl

Update of /home/projects/pgsql/cvsroot/pgsql/src/include/optimizer
     from hub.org:/home/projects/pgsql/tmp/cvs-serv74468/include/optimizer

Modified Files:
    paths.h planmain.h

-----------------------------  Log Message  -----------------------------

Deduce equality constraints that are implied by transitivity of
mergejoinable qual clauses, and add them to the query quals.  For
example, WHERE a = b AND b = c will cause us to add AND a = c.
This is necessary to ensure that it's safe to use these variables
as interchangeable sort keys, which is something 7.0 knows how to do.
Should provide a useful improvement in planning ability, too.

Re: pgsql/src/include/optimizer (paths.h planmain.h)

От
Bruce Momjian
Дата:
>   Date: Sunday, July 23, 2000 @ 23:10:54
> Author: tgl
>
> Update of /home/projects/pgsql/cvsroot/pgsql/src/include/optimizer
>      from hub.org:/home/projects/pgsql/tmp/cvs-serv74468/include/optimizer
>
> Modified Files:
>     paths.h planmain.h
>
> -----------------------------  Log Message  -----------------------------
>
> Deduce equality constraints that are implied by transitivity of
> mergejoinable qual clauses, and add them to the query quals.  For
> example, WHERE a = b AND b = c will cause us to add AND a = c.
> This is necessary to ensure that it's safe to use these variables
> as interchangeable sort keys, which is something 7.0 knows how to do.
> Should provide a useful improvement in planning ability, too.
>

Hard to imagine this didn't happen before.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026