Re: [HACKERS] Re: [GENERAL] big bad join problems - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: [HACKERS] Re: [GENERAL] big bad join problems
Date
Msg-id 199902020302.WAA08587@candle.pha.pa.us
Whole thread Raw
In response to Re: [HACKERS] Re: [GENERAL] big bad join problems  (Vadim Mikheev <vadim@krs.ru>)
List pgsql-hackers
> Bruce Momjian wrote:
> > 
> > > On Mon, 1 Feb 1999, Bruce Momjian wrote:
> > >
> > >       Actually, it's still fairly slow.  I've got two things that my
> > > view is pulling back now, and it's taking quite a while.  I'm going to
> > > load up a bunch of data and see if it gets any slower.  Is there an actual
> > > problem happening here?
> > 
> > With the GEQO problems people were having, I have modified the default
> > GEQO start table count from 8 to 6.
> > 
> > People are having trouble at values of > 6 for a while, but
> > someone(Vadim?) objected to setting it to six in the past.  With two
> > people having problems today, I wanted to lower it.
> 
> Yes, it was me. I don't object against 6, but just remember that
> there were other people having troubles with GEQO and this is
> why table count was increased from 6 to 8.

Do you remember what problems?

--  Bruce Momjian                        |  http://www.op.net/~candle maillist@candle.pha.pa.us            |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026
 


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] Small patches in copy.c and trigger.c
Next
From: Vadim Mikheev
Date:
Subject: Re: [HACKERS] Re: [GENERAL] big bad join problems