Postgres Pro
Downloads
Home   >   mailing lists

What algorithm does the random() function use? - Mailing list pgsql-novice

From Thomas Harold
Subject What algorithm does the random() function use?
Date
Msg-id 495A134E.30209@nybeta.com
Whole thread Raw
Responses Re: What algorithm does the random() function use?
List pgsql-novice
Tree view 
So how good is the random() function in pgsql?  How many iterations
through the PRNG before the PRNG loops?

Does it depend on the underlying O/S?  Which, in our case, is CentOS 5,
64bit.

(I ask, because back in my Visual Basic days, I ran into an issue where
the built-in PRNG would loop after 30 bits worth had been used.  Which
caused issues in a situation where we really need a whole lot more
length in our PRNG.)

pgsql-novice by date:

Previous
From: Bruce Hyatt
Date:
Subject: Re: Fw: Re: connection refused
Next
From: Tom Lane
Date:
Subject: Re: What algorithm does the random() function use?