Tom Lane wrote:
> CVSROOT:      /cvsroot
> Module name:  pgsql-server
> Changes by:   [EMAIL PROTECTED]       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
  [EMAIL PROTECTED]               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

               http://archives.postgresql.org

Reply via email to