↑↓ select↵ open⌫ change scopeOpen full search

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

Wiki / Configuration Parameters

geqo_generations

Controls the number of generations used by GEQO, that is the number of iterations of the algorithm. It must be at least one, and useful values are in the same range as the pool size. If it is set to zero (the default setting) then a suitable value is chosen based on geqo_pool_size.

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
0 means use a suitable default value.
lang
en
max val
2147483647
metadata version
18
min val
0
name
geqo_generations
short desc
GEQO: number of iterations of the algorithm.
source
pg-settings-source-snapshot
unit
Unknown
vartype
integer

Definition PG 18

Controls the number of generations used by GEQO, that is the number of iterations of the algorithm. It must be at least one, and useful values are in the same range as the pool size. If it is set to zero (the default setting) then a suitable value is chosen based on geqo_pool_size.

Compare versions

Source references

Full definition and evidence JSON

Definition sources

center · PostgreSQL 18 · wiki-repair-20261023:758674978ad060474873156fb705c88e92aeeb30a0f501cb4109cf7ad4c9ddf2

Text language: en · wiki-repair-20261023:758674978ad060474873156fb705c88e92aeeb30a0f501cb4109cf7ad4c9ddf2