| From: | Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us> |
|---|---|
| To: | vadim(at)krs(dot)ru (Vadim Mikheev) |
| Cc: | dustin(at)spy(dot)net, hackers(at)postgreSQL(dot)org |
| Subject: | Re: [HACKERS] Re: [GENERAL] big bad join problems |
| Date: | 1999-02-02 03:38:32 |
| Message-ID: | 199902020338.WAA11337@candle.pha.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
> > > 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).
My rememberance was that GEQO was slower for some 6-table joins, so it
was recommended to keep it at 8. Tom clearly is on the proper track in
checking the number of indexes when using GEQO. That should allow us to
set a proper value that will use GEQO in most/all cases.
--
Bruce Momjian | http://www.op.net/~candle
maillist(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 1999-02-02 03:57:04 | TEMP tables applied |
| Previous Message | Dustin Sallings | 1999-02-02 03:35:38 | Re: [HACKERS] Re: [GENERAL] big bad join problems |