Re: [HACKERS] bushy plans

> > Please tell me what they are supposed to do.  I can get it working, I
> > think.  I will not remove it.  I have ifdef'ed it, though.  If you tell
> > me what it is, I will check it to see if it works.
> 
> It doesn't work (failed assertion).
> 
> Well, currently both geqo and old optimizer produces
> left-sided plans: inner relation of an join is always
> _base_ relation (not join relation). In bushy plans
> both outer and inner relations may be join ones.
> ~1.5 - 2 years ago I added right-sided plans:
> outer relation is base, inner relation may be join.
> Sometimes right-sided plans are 30% faster than left-sided.
> Bushy plans could be more faster...
> BTW, I broke execution of right-sided plans ~ 1 year ago
> while implementing subqueries (near materialization node)
> and still have no time to fix it (seems no one except me
> used them so I didn't worry about this -:)).

This explaination helps greatly.  This clears up what is happening in
the code.  I will keep the bushy stuff, and see if I can get it working,
though if the problem is outside of the optimizer, I will have trouble.

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