Re: [HACKERS] Bushy Plans fixed

From: Vadim Mikheev <vadim(at)krs(dot)ru>
To: Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>
Cc: hackers(at)postgreSQL(dot)org
Subject: Re: [HACKERS] Bushy Plans fixed
Date: 1999-02-18 04:35:39
Message-ID: 36CB989B.25BFBAB9@krs.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Vadim Mikheev 1999-02-18 04:42:31 Re: [HACKERS] 8K block limit
Previous Message D'Arcy J.M. Cain 1999-02-18 03:59:32 Re: [HACKERS] 6.4.3? and version numbers