Tom Lane wrote:
> CVSROOT: /cvsroot
> Module name: pgsql-server
> Changes by: tgl@svr1.postgresql.org 03/09/07 12:26:54
>
> Modified files:
> doc/src/sgml : runtime.sgml
> src/backend/optimizer/geqo: geqo_main.c
> src/backend/utils/misc: guc.c postgresql.conf.sample
> src/bin/psql : tab-complete.c
> src/include/optimizer: geqo.h
>
> Log message:
> 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.
Tom, I see 'set seed' works:
test=> set seed = 0;
SET
but where is it documented?
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073