From: | Neil Conway <neilc(at)samurai(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | PostgreSQL Patches <pgsql-patches(at)postgresql(dot)org> |
Subject: | Re: improve join_collapse_limit docs |
Date: | 2004-01-27 16:36:54 |
Message-ID: | 87ptd5s5zt.fsf@mailbox.samurai.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-patches |
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> writes:
> This should include some weasel-wording along the lines of "At
> present, blah blah blah".
Good point, thanks.
> It is theoretically legal to reorder outer joins in some cases
Indeed; see "Outerjoin Simplification and Reordering for Query
Optimization" by Gelindo-Legaria and Rosenthal (ACM TDS, Vol. 22,
No. 1, March 1997, Pages 43-74), for example.
> I harbor ambitions of teaching the planner about that sooner or
> later.
Indeed, I've speculated about doing this myself at some indeterminate
point in the future. Of course (a) your knowledge of the optimizer
dwarfs my own by several orders of magnitude (b) I don't have any firm
plans to do this, it just looked like an interesting problem. So
please don't let me stop you implementing this yourself at your
leisure.
I've fixed the other minor points you raised and applied the patch --
thanks for the feedback.
-Neil
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2004-01-27 17:16:23 | Re: ANALYZE patch for review |
Previous Message | Mark Cave-Ayland | 2004-01-27 13:44:00 | Re: ANALYZE patch for review |