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

From Bruce Momjian
Subject Re: [HACKERS] optimizer, again...
Date
Msg-id a7916718d2c9ec2d18c0c18d55289c2f
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: The Hermit Hacker
Date:
Subject: [none]
Next
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] optimizer, again...