On Thursday 16 July 2009 23:04:58 Tom Lane wrote: > Andres Freund <and...@anarazel.de> writes: > > Query planning via GEQO currently can yield a different plan on every > > invokation of the planner due to its non-exhaustive nature. > > This often can be inconvenient because at times there may be a very > > bad plan. It also makes it very hard to reproduce a problem with GEQO. > > Applied with some editorialization. Mainly, I didn't see the point of > preserving the ability to have nondeterministic planning, and I > especially didn't care for having that still be the default behavior. > So I just made it unconditionally initialize the seed. It would of > course take only minor tweaking to do things differently. Nice. Mainly I did not have the guts to change the behaviour completely...
archive.org has a copy of the dead link to the comp.ai.genetic FAQ linked at http://web.archive.org/web/20051226001402/http://www.cs.bham.ac.uk/Mirrors/ftp.de.uu.net/EC/clife/www/location.htm which is the same as the one referenced by alvaro in http://archives.postgresql.org/pgsql-docs/2009-07/msg00004.php If considerered relevant enough, you can update the link... Andres -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers