Re: pgbench randomness initialization - Mailing list pgsql-hackers

From Tom Lane
Subject Re: pgbench randomness initialization
Date
Msg-id 1589.1460036787@sss.pgh.pa.us
Whole thread Raw
In response to Re: pgbench randomness initialization  (Andres Freund <andres@anarazel.de>)
Responses Re: pgbench randomness initialization  (Andres Freund <andres@anarazel.de>)
List pgsql-hackers
Andres Freund <andres@anarazel.de> writes:
> On 2016-04-07 12:25:58 +0200, Fabien COELHO wrote:
>> So I have no mathematical doubt that changing the seed is the right default
>> setting, thus I think that the current behavior is fine. However I'm okay if
>> someone wants to control the randomness for some reason (maybe having "less
>> sure" results, but quickly), so it could be allowed somehow.

> There might be some statistics arguments, but I think they're pretty
> ignoring reality.

Sorry, but I think Fabien is right and you are wrong.  There is no
point in having randomness in there at all if the thing is constrained
to generate the same "random" sequence every time.

I don't object to having an option to force the initial seed, but
it should not be the default, and it most certainly should not be
the only behavior.
        regards, tom lane



pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: Move PinBuffer and UnpinBuffer to atomics
Next
From: Merlin Moncure
Date:
Subject: Re: Why the "UPDATE tab SET tab.col" is invalid?