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

From Vadim B. Mikheev
Subject Re: [HACKERS] optimizer, again...
Date
Msg-id 7a8724389d6b06749c3531528f161618
Whole thread Raw
List pgsql-hackers
Bruce Momjian wrote:
>
> > > If GEQO is defaulting to ON, I think this should be &&?
> > >
> > > Comments?
> >
> > && would be nice in conjunction with SET geqo to 'on=XXX'.
> >                                                     ^^^^
> > If no one has time to implement it...
>
> If we don't change add SET GEQO TO ON=xxx, should the || be changed to
> &&?

You're right! I thought I don't object || (I have GEQO OFF by default
and don't use > 4 tables in joins), but I object it now:
as it was mentioned by many ppl, GEQO optimization times are quite
bad for 2-3-? relations!

Vadim

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

pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: [HACKERS] 6.1 progress
Next
From: "Vadim B. Mikheev"
Date:
Subject: Re: [HACKERS] optimizer, again...