↑↓ select↵ open⌫ change scopeOpen full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Wiki / Configuration Parameters

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.

English manual coverage begins with PostgreSQL 7.4. Source history and runtime observations have their own recorded version boundaries.

Reading PG 18·Select a recorded version

boot val
0
category
Query Tuning / Genetic Query Optimizer
context
user
documented
true
enumvals
Unknown
extra desc
Unknown
lang
en
max val
1
metadata version
18
min val
0
name
geqo_seed
short desc
GEQO: seed for random path selection.
source
pg-settings-source-snapshot
unit
Unknown
vartype
real

Definition PG 18

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.

Compare versions

Source references

Full definition and evidence JSON

Definition sources

center · PostgreSQL 18 · wiki-repair-20261023:05945f7a63ad1e1224c462a358277a6901ba1054ecd63358430507de59c87cbe

Text language: en · wiki-repair-20261023:05945f7a63ad1e1224c462a358277a6901ba1054ecd63358430507de59c87cbe