PostgreSQL version:

geqo_seed

Controls the initial value of the random number generator used by GEQO to select random paths through the join order search space. The value can range from zero (the default) to one. Varying the value changes the set of join paths explored, and may result in a better or worse best path being found.

Recommendations

If you set this manually, you can force repeatable execution paths for GEQO queries.

Comments