Re: PSA: we lack TAP test coverage on NetBSD and OpenBSD - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: PSA: we lack TAP test coverage on NetBSD and OpenBSD
Date
Msg-id 201901241645.e5syn5lxjldb@alvherre.pgsql
Whole thread Raw
In response to Re: PSA: we lack TAP test coverage on NetBSD and OpenBSD  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On 2019-Jan-24, Tom Lane wrote:

> > Also, as 
> > the pseudo-random state is fully controlled, seeded test results are 
> > deterministic so the expected value can be fully checked.
> 
> I found that the "expected value" was different in v11 than HEAD,
> which surprised me.  It looks like the reason is that HEAD sets up
> more/different RandomStates from the same seed than v11 did.  Not
> sure if it's a good thing for this behavior to change across versions.

The rationale behind this was that some internal uses of random numbers
messed up the determinism of user-invoked random functions; 409231919443
commit message says

    While at it, use separate random state for thread administratrivia such
    as deciding which script to run, how long to delay for throttling, or
    whether to log a message when sampling; this not only makes these tasks
    independent of each other, but makes the actual thread run
    deterministic.

-- 
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services


pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: problems with foreign keys on partitioned tables
Next
From: Konstantin Knizhnik
Date:
Subject: Built-in connection pooler