Re: Random not so random

From: Harald Fuchs <hf0722x(at)protecting(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Random not so random
Date: 2004-10-06 13:13:35
Message-ID: puoejgm1kw.fsf@srv.protecting.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

In article <D425483C2C5C9F49B5B7A41F89441547055523(at)postal(dot)corporate(dot)connx(dot)com>,
"Dann Corbit" <DCorbit(at)connx(dot)com> writes:

> A better way would be to seed a Mersenne Twister PRNG at server startup
> time and then use the same generator for all subsequent calls.
> http://www.math.sci.hiroshima-u.ac.jp/~m-mat/MT/emt.html

> The period is exceptionally long, and it has many excellent properties.

I think you're slightly missing the point. Every PRNG always returns
the same output swquence for the same seed, and that's the problem
with the current implementation: it might happen that two backends get
the same seed.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Justin Wyer 2004-10-06 13:20:17 (no subject)
Previous Message Holger Klawitter 2004-10-06 12:37:31 Re: OT: spherical geometry (Re: earthdistance is not giving ...)