Re: [HACKERS] optimizer, again...

>
> Bruce Momjian wrote:
> >
> > I have found the following patch from Martin and have installed it in
> > the source tree.
> >
> > It enables GEQO if more than six tables is used.
> >
> > > 4.) I vote for a standard PG optimizer/GEQO switch.
> > >     It can be deprecated later on.
> > >     Till 6 relation in a query: standard PG optimizer
> > >     More than 6 relation in a query: GEQO
> > >     Patches are included.
> > >
> > >
> > > !     if ( (_use_geqo_) || length(root->base_relation_list_) >= GEQO_RELS )
>                             ^^
> though it's not what I suggested, I don't object...

Man, Vadim is sharp.

I never saw this.

If GEQO is defaulting to ON, I think this should be &&?

Comments?

- --
Bruce Momjian
maillist@candle.pha.pa.us

------------------------------