Re: [HACKERS] optimizer, again...

Bruce Momjian wrote:
>
> >
> > 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?

&& would be nice in conjunction with SET geqo to 'on=XXX'.
                                                    ^^^^
If no one has time to implement it...

Vadim

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