Re: [HACKERS] Re: [GENERAL] big bad join problems

Поиск
Список
Период
Сортировка
От Vadim Mikheev
Тема Re: [HACKERS] Re: [GENERAL] big bad join problems
Дата
Msg-id 36B66F2D.D7BB9660@krs.ru
обсуждение исходный текст
Ответ на Re: [HACKERS] Re: [GENERAL] big bad join problems  (Bruce Momjian <maillist@candle.pha.pa.us>)
Ответы Re: [HACKERS] Re: [GENERAL] big bad join problems  (Dustin Sallings <dustin@spy.net>)
Re: [HACKERS] Re: [GENERAL] big bad join problems  (Bruce Momjian <maillist@candle.pha.pa.us>)
Список pgsql-hackers
Bruce Momjian wrote:
> 
> > 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?

No. Either the same as now (long planning) or bad plans
(long execution).

Vadim


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: [HACKERS] Re: [GENERAL] big bad join problems
Следующее
От: "Thomas G. Lockhart"
Дата:
Сообщение: Re: [DOCS] Re: [HACKERS] Re: [COMMITTERS] [WEBMASTER] 'www/html main.html'