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

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Tom Lane <tgl(at)hub(dot)org>
Cc: pgsql-committers(at)postgresql(dot)org
Subject: Re: pgsql/src/include/optimizer (paths.h planmain.h)
Date: 2000-07-27 18:53:44
Message-ID: 200007271853.OAA26975@candle.pha.pa.us
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-committers

> 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(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026

In response to

Browse pgsql-committers by date

  From Date Subject
Next Message Bruce Momjian - CVS 2000-07-27 19:11:47 pgsql/doc (TODO)
Previous Message Bruce Momjian - CVS 2000-07-27 18:51:41 pgsql/doc (TODO)