Darren King wrote:
>
> Is GEQO behaving for everyone? Since line 160 of geqo_eval.c has
> been commented out, GEQO has been behaving very strangely for me.
> If I remove the #ifdef 0 and let it call compute_rel_size(), it
> seems to work. Does the geqo need this?
>
> If I leave that line out, it tries to put sorts in the middle of
> plans and the join sequences make no sense. Using my test data,
> the standard optimizer returns in about 9 seconds while geqo will
> keep going seemingly forever and creating a temp file in the
> data/base/dir. I've killed it after more than a minute before it
> uses up all of my space.
>
> If I uncomment that call to compute_rel_size() it returns in about
> 9 seconds too!
compute_rel_size() call restored as
if ( rel->size <= 0 )
rel->size = compute_rel_size(rel);
for both GEQO & old opt-r.
Vadim
------------------------------
