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...
Vadim
------------------------------