Re: Make planning via GEQO repeatable - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Make planning via GEQO repeatable
Date
Msg-id 15503.1247778298@sss.pgh.pa.us
Whole thread Raw
In response to Make planning via GEQO repeatable  (Andres Freund <andres@anarazel.de>)
Responses Re: Make planning via GEQO repeatable
List 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 by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: COPY WITH CSV FORCE QUOTE *
Next
From: Euler Taveira de Oliveira
Date:
Subject: Re: Docbook toolchain interfering with patch review?