Re: [HACKERS] optimizer, again... - Mailing list pgsql-hackers

From Vadim B. Mikheev
Subject Re: [HACKERS] optimizer, again...
Date
Msg-id 814a32d6f5e925f41f1c10612c7d9c07
Whole thread Raw
List pgsql-hackers
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

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

pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: [HACKERS] 6.1 issues resolved
Next
From: "Vadim B. Mikheev"
Date:
Subject: fixed: Re: [HACKERS] Bug in CREATE TABLE