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
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) |