Re: Random not so random
Harald Fuchs <hf0722x@protecting.net>
From: Harald Fuchs <hf0722x@protecting.net>
To: pgsql-general@postgresql.org
Date: 2004-10-05T12:39:13Z
Lists: pgsql-general
In article <20041004155742.GA8488@wolff.to>, Bruno Wolff III <bruno@wolff.to> writes: > On Mon, Oct 04, 2004 at 10:14:19 -0400, > Tom Lane <tgl@sss.pgh.pa.us> wrote: >> >> It occurs to me that you might be seeing predictability as an indirect >> result of something else you are doing that somehow tends to synchronize >> the backend start times. Are you connecting from a cron script that >> would tend to be launched at the same relative instant within a second? >> >> It might improve matters to make the code do something like >> >> srandom((unsigned int) (now.tv_sec ^ now.tv_usec)); > Using /dev/urandom, where available, might be another option. However, some > people may not want their entropy pool getting 4 bytes used up on every > connection start up. I think we don't need the randomness provided by /dev/[u]random. How about XORing in getpid?