Re: Genetic Query Optimizer

"James L. Hubbard III" <jhubbard(at)mcs(dot)uvawise(dot)edu> writes:
> Who works on the genetic query optimizer (geqo)?

AFAIK, no one has touched the genetic algorithm itself in years --- not
since the original contributor, who has not been heard from in awhile.
The only changes to that code have been to clean up its interfaces to
the rest of the system (eg, make it use the new GUC mechanism to accept
parameters).

If you want to work on it, go right ahead!

> Does it need to be improved?

Finding better plans in less time is always better.

There aren't that many people using GEQO at the moment, I suspect,
just because there aren't that many people doing umpteen-way joins.
But I think it would be cool if it became a useful alternative to
the standard exhaustive optimizer at a lower crossover point.

regards, tom lane