Remove geqo_random_seed parameter. Having geqo reset the global random()
Tom Lane <tgl@sss.pgh.pa.us>
Remove geqo_random_seed parameter. Having geqo reset the global random() sequence every time it's called is bogus --- it interferes with user control over the seed, and actually decreases randomness overall (because a seed based on time(NULL) is pretty predictable). If you really want a reproducible result from geqo, do 'set seed = 0' before planning a query.
Files
| Path | Change | +/− |
|---|---|---|
| doc/src/sgml/runtime.sgml | modified | +2 −5 |
| src/backend/optimizer/geqo/geqo_main.c | modified | +1 −9 |
| src/backend/utils/misc/guc.c | modified | +1 −10 |
| src/backend/utils/misc/postgresql.conf.sample | modified | +0 −1 |
| src/bin/psql/tab-complete.c | modified | +1 −2 |
| src/include/optimizer/geqo.h | modified | +1 −3 |