Re: Make planning via GEQO repeatable

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Make planning via GEQO repeatable
Дата
Msg-id 15503.1247778298@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Make planning via GEQO repeatable  (Andres Freund <andres@anarazel.de>)
Ответы Re: Make planning via GEQO repeatable  (Andres Freund <andres@anarazel.de>)
Список pgsql-hackers
Andres Freund <andres@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.
        regards, tom lane


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

Предыдущее
От: Andrew Dunstan
Дата:
Сообщение: Re: COPY WITH CSV FORCE QUOTE *
Следующее
От: Euler Taveira de Oliveira
Дата:
Сообщение: Re: Docbook toolchain interfering with patch review?