diff options
author | Tom Lane <tgl@sss.pgh.pa.us> | 2003-09-07 15:26:54 +0000 |
---|---|---|
committer | Tom Lane <tgl@sss.pgh.pa.us> | 2003-09-07 15:26:54 +0000 |
commit | 48beecda7cbd2e73ebc11c88d3567ad064604bda (patch) | |
tree | bbe6fd0b76dc6ac7f18cefa3bb86ce19eec5c8b5 /src/backend/utils/misc/guc.c | |
parent | 75c35e0f313d58fbbc65169dec13ce19e9886c99 (diff) | |
download | postgresql-48beecda7cbd2e73ebc11c88d3567ad064604bda.tar.gz postgresql-48beecda7cbd2e73ebc11c88d3567ad064604bda.zip |
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.
Diffstat (limited to 'src/backend/utils/misc/guc.c')
-rw-r--r-- | src/backend/utils/misc/guc.c | 11 |
1 files changed, 1 insertions, 10 deletions
diff --git a/src/backend/utils/misc/guc.c b/src/backend/utils/misc/guc.c index 2129042ed25..709f3090d1a 100644 --- a/src/backend/utils/misc/guc.c +++ b/src/backend/utils/misc/guc.c @@ -10,7 +10,7 @@ * Written by Peter Eisentraut <peter_e@gmx.net>. * * IDENTIFICATION - * $Header: /cvsroot/pgsql/src/backend/utils/misc/guc.c,v 1.155 2003/09/04 05:11:20 momjian Exp $ + * $Header: /cvsroot/pgsql/src/backend/utils/misc/guc.c,v 1.156 2003/09/07 15:26:53 tgl Exp $ * *-------------------------------------------------------------------- */ @@ -898,15 +898,6 @@ static struct config_int ConfigureNamesInt[] = &Geqo_generations, 0, 0, INT_MAX, NULL, NULL }, - { - {"geqo_random_seed", PGC_USERSET, QUERY_TUNING_GEQO, - gettext_noop("Can be set to get reproducible results from the algorithm"), - gettext_noop("If it is set to -1 then the algorithm behaves " - "non-deterministically") - }, - &Geqo_random_seed, - -1, INT_MIN, INT_MAX, NULL, NULL - }, { {"deadlock_timeout", PGC_SIGHUP, LOCK_MANAGEMENT, |