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
------------------------------