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
Re: [HACKERS] Re: [GENERAL] big bad join problems |
Список | 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 по дате отправления: