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:53:34 |
Message-ID: | 3A43E97E.26469F66@austin.rr.com |
Views: | Raw Message | Whole Thread | 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.
At risk of being off-topic here, is there a reason why GEQO is off by
default in the ODBC driver (postdrv.exe)? I vaguely recall something
about this from a year ago, but can't find it.
Regards,
Ed Loehr
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2000-12-22 23:54:04 | Re: Unable to check out REL7_1 via cvs |
Previous Message | Alfred Perlstein | 2000-12-22 23:48:34 | Re: Unable to check out REL7_1 via cvs |