Bruce Momjian wrote:
>
> > > Frankly, I would like to enable bushy plans and right-handed plans by
> > > default. The optimizer is now fast enough that a 9-table join is almost
> > > instantaneous, even with bush plans. People are not sophisticated
> > > enough to know when to enables these options themselves. I am not sure I
> > > am either. I would like to enables both, fix whatever breaks, and
> > > programmatically enable the options when they make sense.
> >
> > We need not in right-sided plans code any more.
> > I agreed that we should enable bushes by default.
>
> Are you saying right-hand plans are not useful if we have bushy plans?
> If so, I will remove the right-hand code.
I mean that bushes should be able to produce right-sided plans.
So - remove right-sided coded.
Vadim
