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

From Vadim B. Mikheev
Subject Re: [HACKERS] optimizer, again...
Date
Msg-id f59577d0f644f54511bd057c6ba608a2
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: The Hermit Hacker
Date:
Subject: Re: [HACKERS] 6.1 issues resolved
Next
From: Ross Johnson
Date:
Subject: Re: [HACKERS] Re: [COMMITTERS] 'postgres95/src/bin/destroydb destroydb.sh'