Re: Bunch o' dead code in GEQO

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Bunch o' dead code in GEQO
Дата
Msg-id 24231.1074834642@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Bunch o' dead code in GEQO  (Neil Conway <neilc@samurai.com>)
Ответы Re: Bunch o' dead code in GEQO  (Neil Conway <neilc@samurai.com>)
Список pgsql-hackers
Neil Conway <neilc@samurai.com> writes:
> Tom Lane <tgl@sss.pgh.pa.us> writes:
>> I'm assuming that the original author of the GEQO code already did
>> that testing ...

> Removing the code without bothering to verify this assumption is a
> little unwise, IMHO:

Fair enough.  I did a little bit of poking around and it seems that
ERX (edge-recombination crossover) is still considered one of the best
available choices for solving Traveling Salesman problems via genetic
optimization.  Now there is the little issue that our problem isn't
really TSP and might behave a bit differently, but I see no evidence
to suggest that one of the other recombinator methods would do better.
They were all designed to do TSP.

The big problem here is that I don't see any practical method of
obtaining indisputable proof that one method is better than another.
Where are we going to find a representative test set of dozen-or-more-
way SQL join queries?
        regards, tom lane


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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: Permissions and PGSQL
Следующее
От: Tom Lane
Дата:
Сообщение: Re: LWLock/ShmemIndex startup question