RE: GEQO status?

Поиск
Список
Период
Сортировка
От Andrew Snow
Тема RE: GEQO status?
Дата
Msg-id JEEGIJPOJIGGIIHGKOKOOEBCCHAA.andrew@modulus.org
обсуждение исходный текст
Ответ на AW: GEQO status?  (Zeugswetter Andreas SB <ZeugswetterA@wien.spardat.at>)
Список pgsql-hackers
> I would set Seed per default. Even worse than a bad query path
> is an unpredictable query path. I see no argument, that a random Seed
> would buy us anything.

This kindof bugs me -- if you leave it stuck at a preset value, it makes it
possible to never delve into parts of solution space that have more optimal
solutions than the default seed will ever find.  Surely a random seed would
make the solution better on average over a large number of queries.

On the other hand, if the system as a whole is working well, it should not
matter what the seed is.


- Andrew



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

Предыдущее
От: "Adam Lang"
Дата:
Сообщение: Re: [INTERFACES] PHP and PostgreSQL
Следующее
От: "Adam Lang"
Дата:
Сообщение: Re: [INTERFACES] PHP and PostgreSQL