| From: | Ed Loehr <eloehr(at)austin(dot)rr(dot)com> |
|---|---|
| To: | Thomas Lockhart <lockhart(at)alumni(dot)caltech(dot)edu> |
| Cc: | pghackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: GEQO status? |
| Date: | 2000-12-22 23:10:47 |
| Message-ID: | 3A43DF77.14FABB8D@austin.rr.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Thomas Lockhart wrote:
>
> > What is the status of the genetic algorithm query optimizer? Is this
> > supposed to work well on many-table joins, or has it fallen out of favor
> > or in disrepair? [I'm needing to optimize some large, many-table-join
> > queries and wondering time spent configuring/understanding geqo would be
> > fruitful...]
>
> It is the only techique we have to achieve adequate performance on
> many-table joins. It has received little work recently, but that may be
> due to having received no complaints or discussions that I can recall.
I'm having some trouble, not sure its related to GEQO. Is there a
PGOPTIONS flag to turn it off to attempt isolate the problem?
Ed
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Thomas Lockhart | 2000-12-22 23:14:25 | Re: GEQO status? |
| Previous Message | Tom Lane | 2000-12-22 23:08:38 | Re: GEQO status? |