Skip site navigation (1) Skip section navigation (2)

Re: Genetic Query Optimizer

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "James L(dot) Hubbard III" <jhubbard(at)mcs(dot)uvawise(dot)edu>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Genetic Query Optimizer
Date: 2001-10-02 14:06:21
Message-ID: 8378.1002031581@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackers
"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

In response to

pgsql-hackers by date

Next:From: Vince VielhaberDate: 2001-10-02 14:14:50
Subject: Re: cvsweb
Previous:From: Frank WilesDate: 2001-10-02 14:06:07
Subject: Re: cvsweb

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group