From: | Fabien COELHO <coelho(at)cri(dot)ensmp(dot)fr> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | PostgreSQL Developers <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
Subject: | Re: PSA: we lack TAP test coverage on NetBSD and OpenBSD |
Date: | 2019-01-18 08:37:26 |
Message-ID: | alpine.DEB.2.21.1901180926580.26418@lancre |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
> BTW, if you're wondering why curculio is still failing the pgbench
> test,
Hmmm, that is interesting! It shows that at least some TAP tests are
useful.
> all is explained here:
>
> https://man.openbsd.org/srandom
>
> Or at least most is explained there.
Yep. They try to be more serious than other systems about PRNG, which is
not bad in itself.
> While curculio is unsurprisingly failing all four seeded_random tests,
> when I try it locally on an OpenBSD 6.4 installation, only the uniform,
> exponential, and gaussian cases reliably "fail". zipfian usually
> doesn't.
> It looks like the zipfian code almost always produces 4000 regardless of
> the seed value, though occasionally it produces 4001. Bad parameters
> for that algorithm, perhaps?
Welcome to the zipfian highly skewed distribution! I'll check the
parameters used in the test, maybe it should use something less extreme.
srandom is only used for initializing the state of various internal rand48
LCG PRNG for pgbench.
Maybe on OpenBSD pg should switch srandom to srandom_deterministic?
--
Fabien.
From | Date | Subject | |
---|---|---|---|
Next Message | Amit Langote | 2019-01-18 08:50:56 | Re: using expression syntax for partition bounds |
Previous Message | Kyotaro HORIGUCHI | 2019-01-18 08:33:30 | Re: Protect syscache from bloating with negative cache entries |