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

From Bruce Momjian
Subject Re: [HACKERS] optimizer, again...
Date
Msg-id edcb187e95a219f2e859e407bee78c10
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...

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

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

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