[HACKERS] Re: [PORTS] GEQO broken on 6-6-97?!?

Поиск
Список
Период
Сортировка
От Vadim B. Mikheev
Тема [HACKERS] Re: [PORTS] GEQO broken on 6-6-97?!?
Дата
Msg-id a10dad7011f3fe222e47f4eae853e164
обсуждение исходный текст
Список pgsql-hackers
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

------------------------------

В списке pgsql-hackers по дате отправления: